[SQL] to_timestamp, problem

[Marcin Mazurek]

Hi,
Can anyone explain to me why this doesn't work. Seems to be some stupid (my)
mistake:

mtldb=# SELECT  to_timestamp('05121445482000', 'MMDDHHMISSYYYY');
      to_timestamp
------------------------
 2000-05-12 14:45:48+02
(1 row)

mtldb=# SELECT  to_timestamp('20000512144548', 'YYYYMMDDHHMISS');
 to_timestamp
--------------
 invalid
(1 row)

pg 7.0.3, linux 2.2

tia
mazek

Marcin Mazurek

--  
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/