Military time converion issue

[DrewConn]

I am trying to import date data in the following format into a datetime field using DTS and the DateTimeString transformation tool to do it. However when ever it hits an hour field > 12 it throws a conversion error:

The raw data looks like this:
20050522142901

Source data format used :yyyyMMddhhmmss
Destination data format used: mm-dd-yyyy format.

How can I get SQL to recognize this as a military time value?

Thanks.

 

[jbenson001]

When you import the military time, do you want to ignore the time and just import the date?

 

[jbenson001]

To insert with the format you have you have to do some converstion first to the string

This
20050522142901

needs to be chaned to this for the Insert to work
'20050522 14:29:01'

 

[DrewConn]

Yes I want to ignore the time and only bring in the date

 

[jbenson001]

Then just take the Left 8 chars of the string
Left(<string>, 8)