RE: Boolean dates...

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
><joseluis_delgado_at_yahoo.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>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: sfaroult_at_oriolecorp.com

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).