sql convert string to datetime format

First, review the syntax format of CONVERT (): convert ([length], [, Style]) Second, here pay attention to the meaning of style: style is the conversion of datatime and smalldatetime data to a string by the SQL Server system provided by the

CONVERT (Data_type,expression[,style])CONVERT (varchar (10), field name, conversion format)DescriptionThis style is typically in the time type (Datetime,smalldatetime) and the string type (Nchar,nvarchar,char,varchar)It is only used when converting

Method 1: Convert. todatetime (string) The string format must be yyyy-mm-dd hh: mm: Ss. ========================================================== ========== Method 2: Convert. todatetime (string, iformatprovider) Datetime DT; Datetimeformatinfo

A. A review of the syntax format of CONVERT (): convert ([length], [, Style]) second, here is a note of the meaning of style: style is the conversion style number that is provided by the SQL Server system when converting Datatime and smalldatetime

Use convert in SQL server2000 to get the datetime data type style (full)Processing of date data formats, two examples:CONVERT (varchar (16), time one, 20) results: 2007-02-01 08:02/* time is generally a field in the GETDATE () function or data table

Processing of date data format: Result of convert (varchar (16), time 1, 20): 2007-02-01 08: 02 Result of convert (varchar (10), time 1, 23): 2007-02-01 Statement and query result:Select convert (varchar (100), getdate (), 0): 05 16 2006

Processing of date data formats, two examples:CONVERT (varchar (16), time one, 20) results: 2007-02-01 08:02/* time is generally a field in the GETDATE () function or data table */CONVERT (varchar (10), time one, 23) Result: 2007-02-01/*varchar (10)

CONVERT (varchar (10), field name, conversion format)CONVERT (nvarchar), count_time,121Convert is a date conversion function, typically in the time type (Datetime,smalldatetime) and the string type (Nchar,nvarchar,char,varchar)The 3 parameters of

Original link: http://www.cnblogs.com/Pickuper/articles/2058880.htmlMethod One:convert.todatetime (String)The string format is required and must be YYYY-MM-DD HH:MM:SS================================================Method Two: Convert.todatetime

Method One:convert.todatetime (String)The string format is required and must be YYYY-MM-DD HH:MM:SS================================================Method Two: Convert.todatetime (String, IFormatProvider)DateTime DT;DateTimeFormatInfo Dtformat = new