Re: [GENERAL] Timestamp and compatiblity with MySQL

2000-06-14 Thread 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 ' ). See the section on "Formatting Functions" in the distributio

[GENERAL] Timestamp and compatiblity with MySQL

2000-06-13 Thread Daniel Mendyke
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 times