Re: Boolean dates...

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, Stephen.Lee_at_DTAG.Com 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: joseluis_delgado_at_yahoo.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).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: <Stephen.Lee_at_DTAG.Com
> > INET: Stephen.Lee_at_DTAG.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).
> >
>
> Mladen Gogala
> Oracle DBA
>

>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).