converting general text to date time
im trying to extract time date from:
05:20:2006:18:45:50
i could use the mod function but the data is not in date time format.
How to i convert the above into date time format so that i can extract
the time data from it?
thanks
|