Jared's close. It's 2718 - BC -.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, Dick
Sent: Wednesday, October 22, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Boolean dates...Jared,If that's true there has got to be something a little "strange" in the way that Oracle computes julian dates. Beacuse to_date(728,464,'J') returns 05-JUN-2718, where as to_char(sysdate,'J') returns 2,452,935. (comma's added for clarity)Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Boolean dates...
I think what your boss really means is 'julian' date.
Does he also want his database in mauve?
Try this:
select to_date(bdate,'j') from paam;
That said, the dates in your example are about 700 years
into the future.
Jared
Jose Luis Delgado <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]10/22/2003 08:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Boolean dates...
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).
