I have a time field that is a character field.
It is length 6 and in the format hhmmss.
The problem is that it is in military time and I need it in standard time,, so 133245 would need to be 013245.
I am not sure how to convert it.
Thanks for any help,
Ryan