Datetime field

From: HenrikP(at)mail(dot)ikasths(dot)dk (Henrik Denseje Pedersen)
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Datetime field
Date: 1998-09-17 10:46:51
Message-ID: 3600DAA3D3.371DHENRIKP@mail.ikasths.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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
--

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jose' Soares 1998-09-17 13:28:40 Re: [SQL] Datetime field
Previous Message Jerome Knobl 1998-09-17 08:13:51 Re: [SQL] How to Make Case InSensitive???