Timestamp and compatiblity with MySQL

From: Daniel Mendyke <daniel(at)clacknet(dot)com>
To: pgsql-general(at)postgresql(dot)org(dot)pgsql-questions(at)postgresql(dot)org
Subject: Timestamp and compatiblity with MySQL
Date: 2000-06-06 23:41:15
Message-ID: 393D8C1B.4CAD9F65@clacknet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My application (in perl) has to portible

between both MySQL and Postgres. Most of

the work is rather easy, but I'm having

trouble with TIMESTAMP.

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?

Thanks.

-Daniel

--

To reach me remove the 'nospam.'
my address is 'daniel at clacknet dot com'

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2000-06-07 00:54:00 Re: index problem
Previous Message Tom Lane 2000-06-06 22:14:41 Re: Dump