I wrote a conversion program to convert fields from one table into another table.

I want to convert the Date field (Date 8) and the Time field (Char 8) as in HH:MM:SS into a Datetime field (DateTime 8). Is there an easy way to do this?
Some values in the time field are military time such as 21:30:45. Do I have to worry about SET HOURS to do this?

Thanks very much. I will be working on it too. I guess I would use CTOT() in combination with some other functions.