Yosi,
Missed that one, it makes sense now. The only thing
left is to know what date 728646 really means in the source
system.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i
DBA
-----Original Message-----
From: Yosi Greenfield [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Boolean dates...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).
