X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DD07347580B for ; Mon, 17 Feb 2003 14:52:08 -0500 (EST) Received: from ncc1701.cistron.net (ncc1701.cistron.net [62.216.30.38]) by postgresql.org (Postfix) with ESMTP id 5EC88475461 for ; Mon, 17 Feb 2003 14:52:08 -0500 (EST) Received: from news by ncc1701.cistron.net with local (Exim 3.35 #1 (Debian)) id 18krJA-0003Ei-00 for ; Mon, 17 Feb 2003 20:52:08 +0100 From: miquels@cistron-office.nl (Miquel van Smoorenburg) Subject: Re: convert from an integer to a date Date: Mon, 17 Feb 2003 19:52:08 +0000 (UTC) Organization: Cistron Group Lines: 22 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-15 X-Trace: ncc1701.cistron.net 1045511528 10336 62.216.29.200 (17 Feb 2003 19:52:08 GMT) X-Complaints-To: abuse@cistron.nl X-Newsreader: trn 4.0-test76 (Apr 2, 2001) Originator: miquels@cistron-office.nl (Miquel van Smoorenburg) To: pgsql-sql@postgresql.org Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/410 X-Sequence-Number: 11808 In article , wrote: >How can I convert from integer into date format correctly? traffic=3D# select date(20030212); date=20=20=20=20 ------------ 2003-02-12 (1 row) or traffic=3D# select 20030212::text::date; date=20=20=20=20 ------------ 2003-02-12 (1 row) Mike. --=20 Anyone who is capable of getting themselves made President should on no account be allowed to do the job -- Douglas Adams.