I have a column name TIMESTAMP (varchar) which comes from a .dat file. I want to convert it to DATETIME. I know that varchar cannot be converted to a meaningful datetime. But, is there any workaround. There is no way that i can skip this column. Please HELP. Thanks in advance.