Julian Date?? [message #2269] |
Tue, 02 July 2002 23:14 |
Sachin Gurav
Messages: 1 Registered: July 2002
|
Junior Member |
|
|
Hi,
Will you PLEASE explain me what is JULIAN DATE & how is calculated. What is its importance in Oracle. Where it is used???
|
|
|
Re: Julian Date?? [message #2289 is a reply to message #2269] |
Wed, 03 July 2002 12:06 |
K.SREENIVASAN
Messages: 110 Registered: January 2001 Location: banglore
|
Senior Member |
|
|
sir,
i know something about julian date.if you change your date in to the julian, ithink it will count no of days from the bc.
i am using this one to convert the number into words
select to_char(to_date('5000','j'),'jsp') from dual;
it will give the following result.
FIVE THOUSAND.
K.SREENIVASAN
|
|
|
Re: Julian Date?? [message #2292 is a reply to message #2289] |
Wed, 03 July 2002 13:54 |
alapps
Messages: 11 Registered: June 2002
|
Junior Member |
|
|
Julian date is format from legacy systems (i.e. COBOL). It is in the form YYDDD where YY represented the last two digits of the year and DDD represented the day of the year. It has nothing to do with BC).
For example,
January 28, 1998 would be ==> 98028
December 31, 1999 would be ==> 99365
P.S. Remember Y2K...
|
|
|