question

jacobmat9 avatar image
jacobmat9 asked

How to CAST/CONVERT TimeStamp to DateTime.

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.
datetimevarchar
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.