Adds the number n of units specified by the value i to the given date d. Example: DATEADD(i,n,d) SELECT DATEADD(DAY,3,HireDate) AS age FROM employee; -> adds three days to the starting date of employment of every employee (see the sample database). DAY() This function returns an This function returns an integer representing the day part of the specified date. integer representing the day part of the specified select DAY(<date>) date. select DAY(<date>) This function returns an integer representing the month part of the MONTH() specified date. select This function returns an integer representing the year part of the YEAR() specified date. select YEAR(<date>) String functions are used to manipulate data values in a column, usually of a character data type. Transact-SQL supports the following string functions: Function Explanation Converts the specified ASCII(character) character to the equivalent
DATEADD(i,n,d) Adds the number n of units specified by the value i to the given date d. Example: SELECT DATEADD(DAY,3,HireDate) AS age FROM employee; -> adds three days to the starting date of employment of every employee (see the sample database). DAY() This function returns an integer representing the day part of the specified date. select DAY(<date>) This function returns an integer representing the day part of the specified date. select DAY(<date>) MONTH() This function returns an integer representing the month part of the specified date. select YEAR() This function returns an integer representing the year part of the specified date. select YEAR(<date>) String functions are used to manipulate data values in a column, usually of a character data type. Transact-SQL supports the following string functions: Function Explanation ASCII(character) Converts the specified character to the equivalent
1.0%20SQL-SERVER_N.docx