Date format - Mailing list pgsql-novice

From Dylan Fogarty-MacDonald
Subject Date format
Date
Msg-id 44CD93CE.1000403@gmail.com
Whole thread Raw
Responses Re: Date format
Re: Date format
List pgsql-novice
Hi,

I have two fields of column type 'date' from which I want to output a
formatted date (with PHP).

I understand that MySQL  would use DATE_FORMAT and appropriate %M, %D
commands.
I am having trouble finding the equivalent PostgresQL commands. I am
using PG 7.3.4.

I have found the template patterns for the conversions. I want it to be
in this format:

Day, DD Month YYYY

I do not know the function to format this so.

if to_date() converts a string to date, what converts/formats date to
string?

Thankyou very much.

-Dylan Fogarty-MacDonald
dylan.fm@gmail.com

pgsql-novice by date:

Previous
From: "Carlo Stonebanks"
Date:
Subject: Configuring tsearch2 under windows
Next
From: Michael Glaesemann
Date:
Subject: Re: Date format