Adrian Klaver wrote: > test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI'); > > > to_timestamp > > > ------------------------ > > > 2011-02-26 14:00:00-08 > > > (1 row) > > > > Corrected for the ':': > > > > test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24:MI'); > > > to_timestamp > > > ------------------------ > > > 2011-02-26 14:50:00-08 > > > (1 row) > > > On 9.0.3 corrected for the ':': > > test(5432)aklaver=>select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY > HH24:MI'); > to_timestamp > ------------------------ > 2011-02-26 14:50:00-08 > (1 row) > > > Seems 9.0+ is stricter on its parsing.
Agreed. We have made some cleanups to the to_timestamp code in recent major releases and that is what the user must be seeing. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general