how do i convert 0800, or 1200, or 0200 to type datetime ? my textfile has the times listed like
0800 - 0900A 1100 - 0200P
where A = AM, P = PM
i want the times in the database to be in 12-hour/24-hour datetime format? is that possible?
Yes, it's possible. Start with the string functions to separate the parts of the string, then just put them together in the new format (with maybe an if statement to turn 12-hour am/pm into 24-hour).
ok so i can separate 0800 into 08, 00
then what?
