Re: SQLLDR - char to Date

From: John Henriksen <john.henriksen_at_usa.net>
Date: 2000/07/13
Message-ID: <cswb5.1087$XV1.257309_at_news.uswest.net>#1/1


Thanks Matt!!

The actual winner was
create_ts date(19) 'YYYY-MM-DD-HH24.MI.SS'

It was the accidental format of MM for the minutes instead of the correct MI. That's exactly what the error message was telling me, but I was thinking it was some type of internal conversion problem instead of the obvious. DUH!

Thanks again. Received on Thu Jul 13 2000 - 00:00:00 CEST

Original text of this message