Home > mailing lists

to_timestamp, problem - Mailing list pgsql-sql

From	Marcin Mazurek
Subject	to_timestamp, problem
Date	December 15, 2000 08:30:32
Msg-id	20001215113034.B5251@poznan.mtl.pl Whole thread Raw
Responses	Re: to_timestamp, problem
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:

From: Tulassay Zsolt
Date: 15 December 2000, 07:35:17
Subject: Re: How to represent a tree-structure in a relational database

From: Karel Zak
Date: 15 December 2000, 08:49:49
Subject: Re: to_timestamp, problem

to_timestamp, problem - Mailing list pgsql-sql

Previous

Next