convert 13 years

It mainly describes the actual operation process of SQLServer to use convert to obtain datetime date data. In actual operation, converdatabase uses convert to obtain datetime date data. The following examples include conversions of various date

How to Use substring in oracle Database CONVERT (varchar (12), getdate (), 112), substringgetdate SqlserverI often need to perform some time-type field conversions, but I don't quite remember it. So I collected the following

CONVERT (Data_type,expression[,style])CONVERT (varchar (10), field name, conversion format) DescriptionThis style is generally in the type of time (datetime,smalldatetime) and String type (Nchar,nvarchar,char,varchar)When they are converted to each

ConvertExplicitly converts a data type expression to another data type. Because some requirements often use different date formats, the following can be found inFormat the date in SQL Server. SQL Server supports the data format in the Arabic style

Copy http://www.cnblogs.com/benwu/p/3939044.htmlThe main description is that SQL Server uses convert to obtain datetime date data in the actual operation process, in the actual operation with the SQL Server database using convert to get datetime

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

Give your friends a detailed share of the 2016 China Comprehensive economic reform, the next three years the most efficient way to make money. Foreign brands will be a large number of entry into China, go all e-commerce and new models, to a

The main description is that SQL Server uses convert to obtain datetime date data in the actual operation process, in the actual operation with the SQL Server database using convert to get datetime date data, the following instance contains a

The time format normally deposited in the database is yyyy-mm-ddhh:mm:ss if you want to convert to yyyy-mm-dd Short date format. You can use the CONVERT function. The following is a declaration of the CONVERT function in SQL Server Help:Using

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