Re: Timestamp and compatiblity with MySQL

From: Ron Peterson <rpeterson(at)yellowbank(dot)com>
To: daniel(at)clacknet(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Timestamp and compatiblity with MySQL
Date: 2000-06-14 13:37:02
Message-ID: 39478A7E.BA8D32AC@yellowbank.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)yellowbank(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Peterson 2000-06-14 13:47:32 Re: Postgresql and programming
Previous Message Andrea Aime 2000-06-14 13:00:54 Lock record