Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Converting UNIX time..

Re: Converting UNIX time..

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 22 Aug 2002 09:34:52 +0100
Message-ID: <3d64a22c$0$8506$ed9e5944@reading.news.pipex.net>


"Peter Sylvester" <peters_at_mitre.org> wrote in message news:3D63E33E.53F51DC_at_mitre.org...

> Note: better check to see if the original data was derived from "gmt" or

> "local" Unix time, otherwise you may be off by a number of hours. For
> "local" time, there may also be that daylight savings issue...

Good point. It had only occurred to me after I sent my 'solution' that there weren't necessarily 86400 seconds in every day.

--
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 Thu Aug 22 2002 - 03:34:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US