Re: [GENERAL] Timestamp and compatiblity with MySQL

[Ron Peterson]

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
[EMAIL PROTECTED]