SQL Server convert string to datetime

by 
UPDATE MyTable SET MyDate = CONVERT(datetime, '2009/07/16 08:28:01', 120)

For a full discussion of CAST and CONVERT, including the different date formatting options, see the MSDN Library Link below:

https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to return only the Date from a SQL Server DateTime datatype
  3. Best approach to remove time part of datetime in SQL Server
  4. DateTime2 vs DateTime in SQL Server
  5. SQL query to select dates between two dates
  6. How to combine date from one field with time from another field – MS SQL Server
  7. How can I select the first day of a month in SQL?
  8. How to convert DateTime to VarChar
  9. How to split a single column values to multiple column values?
  10. Get day of week in SQL Server 2005/2008
  11. T-SQL: Round to nearest 15 minute interval
  12. Better techniques for trimming leading zeros in SQL Server?
  13. SQL Server Convert Varchar to Datetime
  14. How Can I use “Date” Datatype in sql server?
  15. How to determine the number of days in a month in SQL Server?
  16. What’s the best way to capitalise the first letter of each word in a string in SQL Server
  17. SQL string comparison, greater than and less than operators
  18. Calculate business hours between two dates
  19. Splitting the string in sql server
  20. How do I query for all dates greater than a certain date in SQL Server?
  21. SQL Server converting varbinary to string
  22. A way to extract from a DateTime value data without seconds
  23. How can I compare time in SQL Server?
  24. Difference of two date time in sql server
  25. How do I remove extended ASCII characters from a string in T-SQL?
  26. How to compare datetime with only date in SQL Server
  27. Getting Dates between a range of dates
  28. UPDATE and REPLACE part of a string
  29. What is the internal representation of datetime in sql server?
  30. SQL SERVER DATETIME FORMAT

Leave a Comment