Received: from yoyo.poznan.mtl.pl (yoyo.poznan.mtl.pl [213.77.113.3]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBFAUO091902 for ; Fri, 15 Dec 2000 05:30:25 -0500 (EST) (envelope-from mazek@yoyo.poznan.mtl.pl) Received: by yoyo.poznan.mtl.pl (Postfix, from userid 1000) id E42301685A; Fri, 15 Dec 2000 11:30:34 +0100 (CET) Date: Fri, 15 Dec 2000 11:30:34 +0100 From: Marcin Mazurek To: pgsql-sql@postgresql.org Subject: to_timestamp, problem Message-ID: <20001215113034.B5251@poznan.mtl.pl> Mail-Followup-To: pgsql-sql@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.2.5i Organization: Multinet S.A. X-Archive-Number: 200012/160 X-Sequence-Number: 494 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/