Re: Date conversion

From: Art S. Kagel <kagel_at_bloomberg.net>
Date: Tue, 11 Aug 1998 13:31:59 -0400
Message-ID: <35D0800F.1F94@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 Tue Aug 11 1998 - 12:31:59 CDT