Mladen Gogala wrote: > > Nope. It's the dates according to the format invented by Booleous > Caesar.
Who was counting his days 'ab urbe condita' (753 BC), hence the 700 years shift. > On 10/22/2003 12:24:30 PM, [EMAIL PROTECTED] wrote: > > > > Are you sure he didn't mean Julian dates? Somewhere, someplace you > > are > > bound to find the algorithm that converts between Julian and > > Gregorian > > dates. I had it .... once .... a long time ago. > > > > > -----Original Message----- > > > > > > 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: <[EMAIL PROTECTED] > > 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). > > > > Mladen Gogala > Oracle DBA > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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).
