Re: Timestamp and compatiblity with MySQL - Mailing list pgsql-general

From Ron Peterson
Subject Re: Timestamp and compatiblity with MySQL
Date
Msg-id 39478A7E.BA8D32AC@yellowbank.com
Whole thread Raw
In response to Timestamp and compatiblity with MySQL  (Daniel Mendyke <daniel@clacknet.com>)
List pgsql-general
Daniel Mendyke wrote:
>
> MySQL allows me to use DATE_FORMAT( col_name, '%D %M %Y' )
> to format the data.  What function or method does Postgres
> provide for formating timestamp data?

Try to_char( timestamp_col_name, 'DD MM YYYY' ).

See the section on "Formatting Functions" in the distribution's included
html documentation for more details.

________________________
Ron Peterson
rpeterson@yellowbank.com

pgsql-general by date:

Previous
From: "Andrea Aime"
Date:
Subject: Lock record
Next
From: Ron Peterson
Date:
Subject: Re: Postgresql and programming