[ACCEPTED]-SQL Server convert string to datetime-datetime

Accepted answer

Score: 113

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

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

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

Score: 28

For instance you can use

update tablename set datetimefield='19980223 14:23:05'
update tablename set datetimefield='02/23/1998 14:23:05'
update tablename set datetimefield='1998-12-23 14:23:05'
update tablename set datetimefield='23 February 1998 14:23:05'
update tablename set datetimefield='1998-02-23T14:23:05'

You need to be careful 4 of day/month order since this will be language 3 dependent when the year is not specified 2 first. If you specify the year first then there is 1 no problem; date order will always be year-month-day.

Source: stackoverflow.com

SQL Server 2005 Get First and Last date for any Month in any Year

What is the internal representation of datetime in sql server?

Calculating number of days between a date and today in SQL Server?

Getting the current date in SQL Server?

DateTime query on only year in SQL Server

What is the meaning of the following SQL Server declaration: datetime2(7)?

Convert varchar dd/mm/yyyy to dd/mm/yyyy datetime

Correct way of setting datetime value to a variable in SQL Server

Get only the Date part of DateTime in mssql

Converting from SQL Date to DateTime in Delphi XE

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.