You can try doing an alter session set nls_date_format ='YYYYMMDD'.
Gene Plagge wrote in message ...
>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 Tue Nov 03 1998 - 16:12:54 CST
