Re: Date problem ---- SOS
From: Jim Winterroth <jwinter_at_qdrs2a.stg.trw.com>
Date: 1995/11/14
Message-ID: <48948c$ed1_at_ns1.nba.TRW.COM>#1/1
Date: 1995/11/14
Message-ID: <48948c$ed1_at_ns1.nba.TRW.COM>#1/1
Are you sure that's correct? I show 10-NOV-96 as 10175 days after 01-JAN-69. Assuming that 9-Nov-95 is actually 9808, use the oracle date functions. 01-JAN-69 is 2440223, so you can add the date number (psudo julian) from your current application and convert to an oracle date, i.e. select to_date((2440223+9808),'J') from dual; returns 09-NOV-95. Received on Tue Nov 14 1995 - 00:00:00 CET