Re: Date conversion

Use to_date:

select to_date(mycolumn,'format')
from mytable;

Example, assuming it's a Julian date:

select to_date(mycolumn,'J')
from my table;

If it were mm/dd/yy format (which it doesn't look like, though):

select to_date(mycolumn,'mm/dd/yy')
from my table;

You get the idea...although I don't know what your field is in the format of - it's kinda odd.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

bubba <brittonb_at_webt.com> wrote in article <35cfb415.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 - 11:36:47 CDT