How do I insert date/time into a ORACLE date field?????? - new to ORACLE

All,

        First of all, thanks for any help in advance. I am new to ORACLE and trying to store date/time information in a date field. I need help in doing the following:

        insert into fi_test(create_date) values ( x );

where x is what I need help in formating. I have tried the following for x:

'1/20/1997 12:34:23'
'12-23-1996 1:435:34'
'1-JAN-97 12:45:43'
Again any help would be appreciated greatly!!!

Glynn Smith
glynn_at_fullnet.net Received on Tue Jan 21 1997 - 00:00:00 CST