Re: Date conversion

If it is a Julian date, number of days since Jan 1, 4712 BC, then the date turns out to be 24-JUN-1952.

select to_date(2434188,'j') from dual;

Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

Art S. Kagel <kagel_at_bloomberg.net> wrote in article <35D0800F.1F94_at_bloomberg.net>...
> bubba wrote:
> >
> > I have an oracle 8 database with the date field as a char(8). (I dind't
set
> > this up).
> >
> > the date is being displayed as '2434188' when I show it on a vb form.
> >
> > What kind of date form is this ?It doesn't look like julian? How can I
> > convert this to regular date formats like 01/01/98?
>
> I assume you cannot talk to the dweeb that coded that data, eh?
>
> I looked at it in bc and it just looks like garbage unless it is:
>
> Number of days since Jan 1, 4671 BC -or-
> Number of hours since Jan 1, 1721 -or-
> Number of minutes since Jan 1, 1994
> Number of seconds since the beginning of some, unknown, month in some,
> indeterminate, year.
>
> Art S. Kagel
>
Received on Wed Aug 12 1998 - 10:42:39 CDT