SQL时间类型转换（SQL time type conversion）.docVIP

SQL时间类型转换（SQL time type conversion） The use of convert: Convert (converted data type, variable / constant / field name, [conversion control parameter]) The use of cast: Cast (variable / constant / field name, converted data type) The use of convert Select, count (*), from, T_Client, where, convert (varchar (10), OrderTime, 120), =convert (varchar (10), getdate (), 120) The use of cast: Cast (variable / constant / field name, converted data type) Select, cast (getdate (), as, varchar (10)) CAST and CONVERT Explicitly converts an expression of a data type to another data type. CAST and CONVERT provide similar functionality. grammar Using CAST: CAST (expression, AS, data_type) Using CONVERT: CONVERT (data_type[(length)], expression [[style]]] parameter Expression Is any valid Microsoft? SQL Server? expressions. For more information, see expressions. Data_type Data types provided by the target system, including bigint and sql_variant. User defined data types cannot be used. For more information about available data types, see data types. Length Optional parameters for data types of nchar, nvarchar, char, varchar, binary, or varbinary. Style Date format style, to convert datetime or smalldatetime data to character data (nchar, nvarchar, char, varchar, nchar or nvarchar data type); string format or style, to real, money or float, smallmoney data to character data (nchar, nvarchar, char, varchar, nchar or nvarchar data type). SQL Server supports data formats in the Arabia style using the Kuwait algorithm. In the table, the two column on the left represents the style value for converting datetime or smalldatetime to character data. Adding 100 to the style value will allow you to get four digit years (yyyy) including century numbers. Without century number (YY), century digital (yyyy) standard Input / output * * - 0 or 100 (*) default values Mon, DD, yyyy, hh:miAM (or PM) 1101 American mm/dd/yyyy 2102 ANSI yy.mm.dd 3103 UK / French dd/mm/yy 4104 Germany dd.mm.yy 5105 Italy D