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

Поиск
Список
Период
Сортировка
От akp geek
Тема select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI')
Дата
Msg-id AANLkTinPpvu+MxOtgiV+F1J7-6SMfjX+fLWwGsr3St91@mail.gmail.com
обсуждение исходный текст
Ответы Re: select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI')
Список 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

В списке pgsql-general по дате отправления: