Date format

From: Sackwitz, Antje <Sackwitz_at_vst.vossloh.de>
Date: Tue, 16 May 2000 11:28:22 +0200
Message-Id: <10499.105721@fatcity.com>

Hi,
I have a long field in my table containing the date in seconds since 01.01.1970.
Now I need a function/procedure to calculate the date in format dd.mm.yyyy min:sec to display date in select statements. Can anyone share knowledge to that task? We are running Oracle8.1.5.

Regards,
Antje

Antje Sackwitz                  Phone: +49-431-7109-514
Vossloh System-Technik GmbH     Fax:   +49-431-7109-675
Edisonstr. 3                    E-Mail: sackwitz_at_vst.vossloh.de
24145 Kiel                              


-----------------------------------------------------------------

Received on Tue May 16 2000 - 04:28:22 CDT