Re: odd dates being retrieved

Mike Hasenkamp wrote in message <7b70gf$6rg_at_masters0.InterNex.Net>...
>Hello,
>
>The date values in my database are stored in seconds with a base (start
>date) of January 1, 1970.
>
>Whenever we try the following sql, we get close to the date we are
>expecting, but we seem to be off by a few hours.
>
>Here's the sql we're trying.
>
>select to_char( (to_date('January, 01, 1970,00:00:00', 'Month, DD, YYYY,
>HH24:MI:SS') + ((912821111)/(60*60*24)) ), 'Month, DD, YYYY,
HH24:MI:SS')
>"Date" from dual
>
>The value returned is:
>
>Date
>-----------------------------
>December , 05, 1998, 01:25:11 (this is AM, I think)
>1 row selected.
>
>I expect the value to be December, 04 1998, 5:25:11 (this should be PM)
>

Just a thought....

Are your dates stored as Zulu (GMT) time or local time? You may need to adjust for time zone. Received on Fri Feb 26 1999 - 21:14:54 CST