String To TIme

dssiddu · Post by **dssiddu** » Thu Oct 02, 2008 3:15 am

Hi All

My Src Field Varchar(6) I/p like this 120000
I want to convert to 12:00:00 of time data type.
Modify does that but i dont want to use that . Done with StringtoTime function no use and also Col[1,2]:Col[3,2]:Col[5,2] also no use
basicaly getting ******** values .

Please shout your solutions Adv thanks a ton ton

ray.wurlod · Post by **ray.wurlod** » Thu Oct 02, 2008 3:26 am

Insert the delimiters THEN invoke StringToTime(). Or specify a time format picture of "%hh%nn%ss" (without delimiters, you will observe) when invoking StringToTime() with the original string.

dssiddu · Post by **dssiddu** » Thu Oct 02, 2008 4:07 am

Hi RAY

Thanks a lot For your info.