Re: Converting UNIX time to GMT

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 21 Aug 2002 15:03:42 +0100
Message-ID: <3d639dbf$0$8505$ed9e5944@reading.news.pipex.net>

"James Cummings" <jc1635_at_nortelnetworks.com> wrote in message news:ak00tj$kej$1_at_bcarh8ab.ca.nortel.com...
> Regardless of the source, if it's stored in the database then
> it's stored as an Oracle DATE data type.

I think what Marc was saying was that his data was stored as a number represetning the number of seconds since 1/1/1970. Something like this (from our helpdesk system)

SQL> select calldat_hdw from call_hdw where rownum=1;

CALLDAT_HDW

---

  131203592

This is the call date field from our helpdesk system which chooses to store dates as numbers (for absolutely no good reason that I can see).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Wed Aug 21 2002 - 09:03:42 CDT