If there is only Char & val types why You not save the DateTime in Char field w/o coverting it to "yyyymmddhhmmss" type just store it as "yyyy-mm-ddThh:mm:ss" thet You should not have a problem with CTOT().
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
