Re: Boolean dates...

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 22 Oct 2003 08:04:24 -0800
Message-ID: <F001.005D3F98.20031022080424@fatcity.com>

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:jonathan@gennick.com

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 Oracle-article-request_at_gennick.com 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: jonathan_at_gennick.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). Received on Wed Oct 22 2003 - 11:04:24 CDT