Received: from mail.ikasths.dk (mail.ikasths.dk [194.182.53.2]) by hub.org (8.8.8/8.8.8) with ESMTP id EAA17012 for ; Thu, 17 Sep 1998 04:46:52 -0400 (EDT) (envelope-from HenrikP@mail.ikasths.dk) Received: from da_pc154 ([194.182.53.214]) by mail.ikasths.dk (post.office MTA v1.9.3b ID# 0-11410) with SMTP id AAA164 for ; Thu, 17 Sep 1998 10:46:51 +0000 From: HenrikP@mail.ikasths.dk (Henrik Denseje Pedersen) To: pgsql-sql@postgreSQL.org Subject: Datetime field Message-Id: <3600DAA3D3.371DHENRIKP@mail.ikasths.dk> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Mailer: Becky! ver 1.24 (beta 4) Date: Thu, 17 Sep 1998 10:46:51 +0000 Hi all... In a database i have created a datetime field.. its works fine, but is there someway i can get the result back in "normal" date format instead of this "Wed Aug 19 00:00:00 1998 MET DST". I need to use it in my program, so i need it in the normal datetime format: wich is : 08-19-98 00:00:00 By the way, im programming in Perl, so if anyone know a funktion to convert it back, that could be helpfull too Yours Sincerely Henrik Pedersen --