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 -> can you set the epoch for julian date in Oracle?

can you set the epoch for julian date in Oracle?

From: Ben <balvey_at_comcast.net>
Date: 15 Feb 2007 05:50:43 -0800
Message-ID: <1171547443.184347.23880@a75g2000cwd.googlegroups.com>


I found this message from a couple of years ago and it looks as though the original poster uses the same type of Julian date that our ERP system uses.

http://tinyurl.com/2w46ee

Our Julian date is just a count of the number of days since 1/1/1900. I also read where Oracle's Julian date is a count from some date B.C. 4715 or something around there. Is there a way to use the built in functions for Julian date if your Julian date is based from days since 1/1/1900? Received on Thu Feb 15 2007 - 07:50:43 CST

Original text of this message

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