How to convert from string to date? SQL Server 2005 Best Practices

SQLUSA

SQL 2005 GRAND SLAM

Microsoft SQL Server 2005 Best Practices

How to convert from string to date?

Execute the following script in Query Editor to demonstrate the conversion from string to date (datetime, smalldatetime):

USE AdventureWorks

SET LANGUAGE us_english

SELECT [Datetime] = CAST('2007-02-28' AS datetime)
SELECT [Datetime] = CAST('2007-02-28' AS smalldatetime)

SELECT [Datetime] = CONVERT(datetime,'2007-02-28')
SELECT [Datetime] = CONVERT(smalldatetime,'2007-02-28')

SELECT [Datetime] = CAST('Feb 28, 2007' AS datetime)
SELECT [Datetime] = CAST('Feb 28, 2007' AS smalldatetime)

SELECT [Datetime] = CONVERT(datetime,'Feb 28, 2007')
SELECT [Datetime] = CONVERT(smalldatetime,'Feb 28, 2007')

SELECT [Datetime] = CAST('Feb 28, 2007 12:07:34.444' AS datetime)
SELECT [Datetime] = CAST('Feb 28, 2007 12:07:34.444' AS smalldatetime)

SELECT [Datetime] = CONVERT(datetime,'Feb 28, 2007 12:07:34.444')
SELECT [Datetime] = CONVERT(smalldatetime,'Feb 28, 2007 12:07:34.444')

SELECT [Datetime] = CAST('2007-02-28 12:07:34.444' AS datetime)
SELECT [Datetime] = CAST('2007-02-28 12:07:34.444' AS smalldatetime)

SELECT [Datetime] = CONVERT(datetime,'2007-02-28 12:07:34.444')
SELECT [Datetime] = CONVERT(smalldatetime,'2007-02-28 12:07:34.444')

SQLUSA - The Best SQL Server 2005 Training in the World