I don't think that he's talking about Julian date , but something more convoluted.
Might I ask what system these dates are coming from?? We use to use an ERP system
called ManMan. They calculated dates starting with 1 being 31-October-1971. I
created a function in the database to convert these as needed. It's definition is:
create or replace FUNCTION Oracle_date(manman_date number) RETURN date IS
odate date;
BEGIN
if(manman_date <= 0) then odate := NULL;
else odate := to_date(manman_date+2441255,'J');
end if;
return odate;
END;
/
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Wednesday, October 22, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Jose Luis,
Is it possible that your boss actually means "Julian date",
not "boolean date"? If you speak the two phrase out loud,
there are enough similarities to allow mispronunciation or
misinterpretation?
I tried one of your date values and it didn't work out so
well, but if the format is _similar_ to the Julian format
employed by Oracle, you might have a better time searching
Google for "julian date" rather than "boolean date". Just
thinking out loud...
Here is what I got using one of the values you displayed:
SQL> select to_date(728283,'J') from dual;
TO_DATE(728
-----------
06-DEC-2719
And here is the Julian date value for today...
SQL> select to_char(sysdate,'J') from dual;
TO_CHAR
-------
2452935
Hope this helps...
-Tim
> 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: Tim Gorman
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: Goulet, Dick
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).
