Jose Luis, The only boolean date I can think of is 'now' vs 'at another time'. You should check your program to see how they convert this - or, if you happen to *know* the meaning of some of the numbers, give a few examples. It can probably be guessed back.
HTH SF >----- ------- Original Message ------- ----- >From: Jose Luis Delgado ><[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 22 Oct 2003 07:19:26 > >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 -- 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).
