Dear Frank,
I am away from my desk for a bit, so I can't test this right now, but if
you are certain that your input data will always have only one space and that
it will always be between the date and time components then you should be able
to SRPL the space with a comma.
Jason
Sent from my iPhone.
On Mar 17, 2015, at 9:27 AM, Frank Taylor
<[email protected]<mailto:[email protected]>> wrote:
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]<mailto:[email protected]>
