Re: INSERT INTO using Date format 19981030

Jeff,

Use the to_date function with the correct date mask:

insert into my_table values(
to_date('19981030','YYYYMMDD') );

• Gene

Jeff Howey wrote in message ...
>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 - 18:01:05 CST