How to convert text column to datetime in SQL

by

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)

More Related Contents:

  1. How can I truncate a datetime in SQL Server?
  2. nvarchar(max) vs NText
  3. Export from SQL Server to Excel
  4. How to get Time from DateTime format in SQL?
  5. Infinite loop CTE with OPTION (maxrecursion 0)
  6. How Can I Log and Find the Most Expensive Queries?
  7. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  8. How to get first and last day of previous month (with timestamp) in SQL Server
  9. How to remove the time portion of a datetime value (SQL Server)?
  10. INSERT INTO vs SELECT INTO
  11. How do I use the CONCAT function in SQL Server 2008 R2?
  12. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  13. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  14. Is it possible to force row level locking in SQL Server?
  15. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  16. How do I get date/time information from a TIMESTAMP column?
  17. How to add xml encoding to xml Output in SQL Server
  18. How to: Create trigger for auto update modified date with SQL Server 2008
  19. Comparing dates stored as varchar
  20. What happens to the primary key Id when it goes over the limit?
  21. SQL Recursive CTE: Finding objects linked by property
  22. Convert decimal time to hours and minutes
  23. Retrieving the date in SQL Server; CURRENT_TIMESTAMP vs GetDate()
  24. Sort Bullets in Database
  25. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  26. In SQL Server, how can I find everywhere a column is referenced?
  27. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  28. Why insert-select to variable table from XML variable so slow?
  29. Generate MD5 hash string with T-SQL
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment