Re: INSERT INTO using Date format 19981030

Hi

If I understand you correctly, you want to use 19981030 string and insert it into an Oracle date column. You would do something like this:

insert into table_a(date1, ...,...,...) values (to_date('19981030', 'yyyymmdd'), ...,...);

Regards,

Oracleguru

Jeff Howey <jeffery.howey_at_mci.com> wrote in article <S7n_1.851$347.3122_at_news.cwix.com>...
> I want to just insert the date format I receive from a program without
> having to format it into Oracle's 31-OCT-98 format. Can I do that? And
if
> so, what is the SQL that you used???/ Thanks!
>
>
>
Received on Fri Oct 30 1998 - 13:19:30 CST