Home » SQL & PL/SQL » SQL & PL/SQL » Epoch date...what is the difference
Epoch date...what is the difference [message #2976] Tue, 27 August 2002 14:17 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
I perform the query:

select to_date('01-JAN-70')+1030053302/86400
from dual;

And get:
23-AUG-02 21:55:02

but when I perform this:

select to_date('01-JAN-1970')+1030053302/86400
from dual;

I get:
22-AUG-02 21:55:02

Any ideas?

Report message to a moderator

Re: Epoch date...what is the difference [message #2977 is a reply to message #2976] Tue, 27 August 2002 14:23 Go to previous message
Joe
Messages: 138
Registered: November 1999
Senior Member
The first query is using: 2070 as the year.

Report message to a moderator

Previous Topic: Re: Passing Name-Value pairs
Next Topic: chr(10) function to read 4 lines
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 15 23:59:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.