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

2011-02-25 Thread akp geek
Hi all - I have recently upgraded from 8.3 to 9.0.2. when I run the following sql in 9.0.2 select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI') I am getting the following error and the sql runs fine in older version Is it my installation issue or library missing? ERROR:

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

2011-02-25 Thread Reid Thompson
On 02/25/2011 09:30 AM, akp geek wrote: Hi all - I have recently upgraded from 8.3 to 9.0.2. when I run the following sql in 9.0.2 select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI') I am getting the following error and the sql runs fine in older version Is it my installation

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

2011-02-25 Thread Adrian Klaver
On Friday, February 25, 2011 6:41:54 am Reid Thompson wrote: On 02/25/2011 09:30 AM, akp geek wrote: Hi all - I have recently upgraded from 8.3 to 9.0.2. when I run the following sql in 9.0.2 select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI') I am getting the

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

2011-02-25 Thread Bruce Momjian
Adrian Klaver wrote: test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI'); to_timestamp

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

2011-02-25 Thread akp geek
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/ HH24MI'); to_timestamp