Hello Jose,
Do you by chance mean Julian (not Boolean) dates? Oracle
does, in fact, handle those. For example, I just used the
following to convert one of your example dates to dd-Mon-yy
format:
SQL> select to_date('728464','J') from dual;
TO_DATE('
---------
05-JUN-18
Does the above conversion look correct to you? One thing I'd
check carefully would be your old system's definition of
Julian date. Over the years, I've heard the term used in at
least two different ways.
I hope this helps. If you need more details, just ask.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to [EMAIL PROTECTED] and
include the word "subscribe" in either the subject or body.
Wednesday, October 22, 2003, 11:19:26 AM, you wrote:
JLD> Hi to all!
JLD> We have an old app that manages something that my boss
JLD> calls: boolean dates.
JLD> He told me that exists an algorithm that manages dates
JLD> as a boolean format.
JLD> We have several tables in this form:
JLD> Note: The following table: PAAM
JLD> has the field BDATE defined as NUMBER.
sql>> select bdate from paam
sql>> where rownum < 6
JLD> BDATE
JLD> ----------
JLD> 728464
JLD> 728434
JLD> 728403
JLD> 728495
JLD> 728283
JLD> now, I need to convert that format to an
JLD> 'understandable' format to get the old data and old
JLD> dates.
JLD> I'm looking (google-ing) for that subject but, without
JLD> luck.
JLD> any ideas? help?, pls...
JLD> Thanks in advance
JLD> Regards!
JLD> JL
JLD> __________________________________
JLD> Do you Yahoo!?
JLD> The New Yahoo! Shopping - with improved product search
JLD> http://shopping.yahoo.com
JLD> --
JLD> Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
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).
