to_timestamp, problem

From: Marcin Mazurek <M(dot)Mazurek(at)poznan(dot)multinet(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: to_timestamp, problem
Date: 2000-12-15 10:30:34
Message-ID: 20001215113034.B5251@poznan.mtl.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Karel Zak 2000-12-15 10:49:47 Re: to_timestamp, problem
Previous Message vs 2000-12-15 10:11:52 readline ??