DateTime Conversion

[fblau]

I get a date value from a DOS batch file DIR command that looks like this:

"02/22/2005 03:49 PM"

When DI imports this to a datetime column, it makes it

02/22/2005 03:49 AM

Any ideas?

[Nicolas Hadj-Blaha]

May be you could try to use the to_date() function to convert the output of the DOS command before assigning it to a global variable.

A possible workaround would be to remove the PM/AM from the output string and reassign it automatically with the to_date() function.

Hope this helps.

Nicolas
www.dataintegrator.net

[BODIpop]

you could take the string in as a varchar. Within a query use a substring to get the time part out do and if then else on the PM/AM characters to decide whether to add 12hrs or not this should give you a 24hr clock.Glue it all back together as a string.and then to_date it.

[dnewton]

It may be the space in between the "3:49" and "PM" that is causing the problem. That is, if it were "3:49PM" (no space) maybe it would convert more cleanly?