Re: select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI')

[akp geek <akpgeek@xxxxxxxxx>]

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 <bruce@xxxxxxxxxx> 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  <bruce@xxxxxxxxxx>        http://momjian.us
 EnterpriseDB                             http://enterprisedb.com

 + It's impossible for everything to be true. +

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general