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

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI')
Date: 2011-02-25 14:30:28
Message-ID: AANLkTinPpvu+MxOtgiV+F1J7-6SMfjX+fLWwGsr3St91@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2011-02-25 14:39:33 Re: pg_dump makes our system unusable - any way to pg_dump in the middle of the day? (postgres 8.4.4)
Previous Message David Johnston 2011-02-25 14:28:59 Re: Index Ignored Due To Use Of View