How to convert text column to datetime in SQL

Question

I have a column that s a text  Remarks  text  null   A sample value is  quot 5 21 2013 9 45 48 AM quot   How do I convert it to a datetime format like this   quot 2013-05-21 09 45 48 000 quot   The reason for the conversion is that I was trying to get the total number of hours between a datetime column and the date stamp in the Remarks column  I was thinking of something like this  Remarks  text  null  - Date Sent  datetime  null   To be clear  the columns represent the datetime an inquiry by a customer was sent  Date Sent  and the last response made by a representative regarding the inquiry  Response   so for a sample of a Date Sent having a value of  quot 2013-05-21 08 00 00 000 quot  and a Response with a value of  quot 5 21 2013 10 00 00 AM quot   I should get a value of 2 00  2 hours   Unfortunately  in the database I m working on  Remarks is a text and Date Sent is a datetime

User · Answer

This works   SELECT STR TO DATE dateColumn    c  e  Y  r   FROM tabbleName WHERE 1

User · Answer

Use convert with style 101   select convert datetime  Remarks  101    If your column is really text you need to convert to varchar before converting to datetime  select convert datetime  convert varchar 30   Remarks   101

User · Answer

In SQL Server   cast text as datetime  select cast  5 21 2013 9 45 48  as datetime

[sql-server] How to convert text column to datetime in SQL

Examples related to sql-server

Examples related to sql-server-2008

Examples related to datetime

Examples related to text