| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Boolean dates...
Actually, Oracle's implementation is a Julian date.
The YYDDD format is most definitely not a Julian date, though many persist in calling it that.
Oracle is using what is called a 'Modified Julian Date'. A Julian date actually begins at Noon on -4712, which is 4713 BC.
That ordinal vs. cardinal number thing will get you every time. :)
http://tycho.usno.navy.mil/mjd.html
Jared
DENNIS WILLIAMS <DWILLIAMS_at_lifetouch.com>
Sent by: ml-errors_at_fatcity.com
10/22/2003 09:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: Boolean dates...
I think this is very perceptive - Julian vs. Boolean. I just want to
mention
that what Oracle calls a Julian date is the number of days since Jan 1,
4712
BC. As far as I know, that is exclusive to Oracle. Other systems define
Julian differently. IIRC, IBM mainframes call the number of days since the
most recent Jan. 1 is the Julian. Oracle uses the ddd format in to_char
and
to_date functions for this, like today is the 295th day of 2003.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, October 22, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L
Jose Luis,
Is it possible that your boss actually means "Julian date", not "boolean date"? If you speak the two phrase out loud, there are enough similarities to allow mispronunciation or misinterpretation?
I tried one of your date values and it didn't work out so well, but if the format is _similar_ to the Julian format employed by Oracle, you might have a better time searching Google for "julian date" rather than "boolean date". Just thinking out loud...
Here is what I got using one of the values you displayed:
SQL> select to_date(728283,'J') from dual;
TO_DATE(728
SQL> select to_char(sysdate,'J') from dual;
TO_CHAR
Hope this helps...
-Tim
> Hi to all!
>
> We have an old app that manages something that my boss
> calls: boolean dates.
>
> He told me that exists an algorithm that manages dates
> as a boolean format.
>
> We have several tables in this form:
>
> Note: The following table: PAAM
> has the field BDATE defined as NUMBER.
>
> sql> select bdate from paam
> sql> where rownum < 6
>
> BDATE
> ----------
> 728464
> 728434
> 728403
> 728495
> 728283
>
> now, I need to convert that format to an
> 'understandable' format to get the old data and old
> dates.
>
> I'm looking (google-ing) for that subject but, without
> luck.
>
> any ideas? help?, pls...
>
> Thanks in advance
>
> Regards!
> JL
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net --
> Author: Jose Luis Delgado
> INET: joseluis_delgado_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com San Diego, California --
> Mailing list and web hosting services
> ----------------------------------------------------------
> ----------- To REMOVE yourself from this mailing list,
> send an E-Mail message to: ListGuru_at_fatcity.com (note
> EXACT spelling of 'ListGuru') and in the message BODY,
> include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also
> send the HELP command for other information (like
> subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: tim_at_sagelogix.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Oct 22 2003 - 14:34:25 CDT
 |
 |