Hi JL, try googling for JULIAN dates not boolean. A reason to use Julian dates could be to allow arithmetic of dates to be either a simple plus or minus returning the number of days. You still have to convert back and forth to normal dates for display and human readability. You can see an explanation or Julian/ Gregorian dates and oracles use thereof for internal arithmetic in Oracle itself at http://orafaq.net/papers/dates_o .doc.
Also look at the to_char and to_date functions as they can convert from Julian and to Julian. eg: SQL> select to_char(sysdate,'J') from dual; TO_CHAR ------- 2452935 SQL> select to_date(2452935,'J') from dual; TO_DATE(2 --------- 22-OCT-03 although i am confused with the numbers that you have below. Maybe your dates do not equate 0 with 01-JAN-4712 (or the correct date in 4713!). hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
