Time format Unix
From: kderaedt <kderaedt_at_hotmail.com>
Date: Tue, 11 Mar 2003 13:09:17 +0100
Message-ID: <3e6dd1ec$0$83872$ba620e4c_at_news.skynet.be>
Date: Tue, 11 Mar 2003 13:09:17 +0100
Message-ID: <3e6dd1ec$0$83872$ba620e4c_at_news.skynet.be>
Hi,
I have a problem with some time / date fields in a table. I'm using a
Oracle database on a Solaris system. Some field in that table are time
fields. This is an example of a field.
Regards
Karel
Received on Tue Mar 11 2003 - 13:09:17 CET
1046170886 this is represented as number of seconds from 00:00:00: UTC, Jan
1, 1970.
How can I reformat this to a more logical date in a select statement?