sql add months to date

CONVERT (varchar), GETDATE (), 121): 2006-05-16 10:57:49.700 Select CONVERT (varchar), GETDATE (), 126): 2006-05-16t10:57:49.827 Select CONVERT (varchar), GETDATE (), ():?????????? 1427 10:57:49:907am In SQL database, there is a class of functions that have to be mentioned, that is, SQL Server datetime function, which is the most common SQL Server process

Label:Select GETDATE () as ' current date ',Datename (Year,getdate ()) as ' year ',Datename (Month,getdate ()) as ' month ',Datename (Day,getdate ()) as ' Day ',Datename (Dw,getdate ()) as ' Week ',Datename (Week,getdate ()) as ' Week number ',Datename (Hour,getdate ()) as ' when ',Datename (Minute,getdate ()) as ' min ',Datename (Second,getdate ()) as ' s 'Results:2009-08-13 23:07:15.403 2009 08 13 Week 433 23 7 15

:49.827Select CONVERT (varchar), GETDATE (), ():???? ?????? 1427 10:57:49:907amSelect CONVERT (varchar), GETDATE (), 131): 18/04/1427 10:57:49:920am2. SQL Server date and time functions1. Current system date, timeSelect GETDATE ()2. DateAdd returns a new datetime value based on adding a period of time to the specified dateExample:

, ", GETDATE ()), ' 1900-02-01 ')14. Get the current day of the weekSelect Datename (Weekday, GETDATE ())15. Current system date, timeSelect GETDATE ()DateAdd. Returns a new DateTime value based on adding a period of time to the specified dateExample: Add 2 days to the dateSelect DATEADD (day,2, ' 2004-10-15 ')--return: 2004-10-17 00:00:00.000DateDiff returns the number of

corresponding to the specified portion of the date, intervalDatename (interval,date) returns the name of the string that corresponds to the specified part of the date, intervalThe setting values for the parameter interval are as follows:value abbreviation (SQL Server) descriptionYear Yy 1753 ~ 9999Quarter Qq Season 1

. Example: Select Datename (Year,getdate ()) as ' year ' Executing the SQL statement above will see the return value of ' 2006 ' The table below lists the most important built-in date functions in SQL Server: function descriptionGETDATE () returns the current date and timeDATEPART () returns a separate part of a

expression: Data_type The data types provided by the target system, including bigint and sql_variant. You cannot use a user-defined data type. Length Optional parameters for nchar, nvarchar, char, varchar, binary, or varbinary data types. Style A date format style whereby DateTime or smalldatetime data is converted to character data (nchar, nvarchar, char, varchar, nchar, or nvarchar data type) or a string format style that will float, Real, money,

Label: Automatically add serial numbers via SQL The project often have some document serial number or process serial number is to create a new record after the automatic generation of a number, such as a new process automatically based on the current date automatically add the process flow number, the following descr

time to the specified dateExample: Add 2 days to the dateSelect DATEADD (day,2, ' 2014-10-15 ')--return: 2014-10-17 00:00:00.000--16. DateDiff returns the number of date and time boundaries across two specified dates.Select DateDiff (Day, ' 2004-09-01 ', ' 2004-09-18 ')--return: 17--17. DatePart returns an integer representing the specified date portion of the s

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 */CONVERT (varchar (10), time one, 23) Result: 2007-02-01/*varchar (10) represents the format of the date output, w

№ 1: The current date is the week ordinal of this month Sql> Select To_char (sysdate, ' YYYYMMDD W HH24:MI:SS ') from dual; To_char (sysdate, ' YY-------------------20030327 4 18:16:09 Sql> Select To_char (sysdate, ' W ') from dual; T-4 № 2: The current date is the day of the one week, note that Sunday is the firs