Oracle-L: Re: Boolean dates...

From: Pete Finnigan <oracle_list_at_peterfinnigan.demon.co.uk>
Date: Wed, 22 Oct 2003 09:29:26 -0800
Message-ID: <F001.005D3FBB.20031022092926@fatcity.com>

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:pete_at_petefinnigan.com
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: oracle_list_at_peterfinnigan.demon.co.uk

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 - 12:29:26 CDT