Postgres Pro
Downloads
Home   >   mailing lists

select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI') - Mailing list pgsql-general

From akp geek
Subject select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI')
Date
Msg-id AANLkTinPpvu+MxOtgiV+F1J7-6SMfjX+fLWwGsr3St91@mail.gmail.com
Whole thread Raw
Responses Re: select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI')
List pgsql-general
Tree view
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/YYYY HH24MI')      " I am getting the following error  and the sql runs fine in older version

Is it my installation issue or library missing? 


ERROR:  invalid value ":5" for "MI"
DETAIL:  Value must be an integer.

********** Error **********

ERROR: invalid value ":5" for "MI"
SQL state: 22007
Detail: Value must be an integer.



Thanks for the help
Regards

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Index Ignored Due To Use Of View
Next
From: Andy Colson
Date:
Subject: Re: pg_dump makes our system unusable - any way to pg_dump in the middle of the day? (postgres 8.4.4)