I have a export file that I am importing that contains a column of DateTime
that imports as Text, I then alter the table to add a DATETIME column so I can
order the data. However I cannot seem to directly convert the Text Column in
to the DateTime Column with an Update {Table} set (RBaseDateTimeColumn) =
(Datetime(TextDateTimeCol))
In the table the Text Date time looks like 03/17/15 00:00:00 I am assuming
because the Datetime function is looking for a comma between the Date and Time
it fails. My work around is to do a CURSOR through the data and set a variable
defined as Datetime to the Text DateTime and then insert that variable into the
DateTime Column, but that take a really long time for all these records. Is
there a better way that I am not thinking of ?
n Frank
Frank Taylor - Director of Information Technology
F.J. O'Hara & Sons, Inc - Araho Transfer Inc.
Boston, MA - Rockland, ME - Miami, FL
Direct Dial - 617-790-3093
Email: [email protected]
