Postgres Pro
Downloads
Home   >   mailing lists

to_timestamp, problem - Mailing list pgsql-sql

From Marcin Mazurek
Subject to_timestamp, problem
Date
Msg-id 20001215113034.B5251@poznan.mtl.pl
Whole thread Raw
Responses Re: to_timestamp, problem  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-sql
Tree view 
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/

pgsql-sql by date:

Previous
From: Tulassay Zsolt
Date:
Subject: Re: How to represent a tree-structure in a relational database
Next
From: Karel Zak
Date:
Subject: Re: to_timestamp, problem