Re: Date conversion

From: Chris Eastwood <Chris.Eastwood_at_NoCrapSpamPleaseACNielsen.Co.UK>
Date: 1998/08/11
Message-ID: <#vYMRCQx9GA.269_at_uppssnewspub05.moswest.msn.net>#1/1


Check out the Oracle TODATE function. This may help you translate some of the date values. I'd suggest changing the column type myself.

Regards

Chris Eastwood
Software Engineer
ACNielsen Ltd
[Quoted] bubba wrote in message <35cf8dc9.0_at_news.webt.com>...
>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?
>
>Help please
>
>brittonb_at_webt.com
>
>
Received on Tue Aug 11 1998 - 00:00:00 CEST

Original text of this message