Thank you all for the suggestion and it's very clear to me now
Regards On Fri, Feb 25, 2011 at 10:02 AM, Bruce Momjian <br...@momjian.us> wrote: > 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 >