Import Excel Date Field
90461Jan 12 2007 — edited May 17 2011The import data from xls function is great, the only problem I can't figure out is when I'm importing date field. I've tried the 01/01/2007 and the 01-Jan-2007 and when I try to import it the format appears as 38734. And the field doesn't get populated. The insert statement looks something like this
insert into RICH (field1, field2, field3,. field4, field5, field6)
values ('value1','value2','value3','value4','value5','value6')
field1-4 are varchar
field5 = number
field6 = data/time
all the values look the same as on the excel sheet except the date which has a to_date function apply and this number format.
eg to_date('38734','')
I'm I missing something in the format that I have to apply to the excel sheet?
Cheers