Importing from excel doesn't work on date fields
711683Jul 13 2009 — edited Oct 21 2009I'm trying to import from an excel file, and two of the fields are dates. When I look at the resulting Insert statement, I see this:
to_date('39896.0', 'MM/DD/YYYY HH:MI:SS')
Which, of course, does not work. Where is this '39896' coming from?
I've seen a few other people with this issue, but no solutions. Is there a suggestion box or something? This tool could be great, but as it stands, even when it works it's too hard to use.