Boolean Dates is simply boss-speak for Julian Dates. There are probably 20
different ways "Julian Dates" can be encoded into an integer.
various ways I've seen "Julian Dates" have been encoded
1) Days since a specific date (this date varies by implementation)
2) first 2 digits are the year, the rest are days since Jan 1 of that
year
3) first 2 digits are the year -- encoded as years since a particular
year
the rest are says since Jan 1 of that year
4) a combination of year (1st 2 digits), Quarter (2nd digit), Month
within the Quarter (3rd digit) and day of month (last 2 digits)
Good look!
Kevin
-----Original Message-----
Sent: Wednesday, October 22, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kevin Toepke
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).
