Return the difference between two date values, in years:
SELECT DATEDIFF(year, '2017/08/25', '2011/08/25') AS DateDiff;
The DATEDIFF() function returns the difference between two dates, as an integer.
DATEDIFF(interval, date1, date2)
Add one year to a date, then return the date:
SELECT DATEADD(year, 1, '2017/08/25') AS DateAdd;
The DATEADD() function adds a time/date interval to a date and then returns the date.
DATEADD(interval, number, date)
Return the current date and time:
SELECT CURRENT_TIMESTAMP;
The CURRENT_TIMESTAMP function returns the current date and time, in a ‘YYYY-MM-DD hh:mm:ss.mmm’ format.
Tip: Also look at the GETDATE() function. Continue reading SQL CURRENT_TIMESTAMP Function
Return the tangent of a number:
SELECT TAN(1.75);
The TAN() function returns the tangent of a number.
TAN(number)
Return the sum of the “Quantity” field in the “OrderDetails” table:
SELECT SUM(Quantity) AS TotalItemsOrdered FROM OrderDetails;
The SUM() function calculates the sum of a set of values.
Note: NULL values are ignored.
SUM(expression)
Return the square of a number:
SELECT SQUARE(64);
The SQUARE() function returns the square of a number.
SQUARE(number)
Return the square root of a number:
SELECT SQRT(64);
The SQRT() function returns the square root of a number.
SQRT(number)
Return the sine of a number:
SELECT SIN(2);
The SIN() function returns the sine of a number.
SIN(number)
Return the sign of a number:
SELECT SIGN(255.5);
The SIGN() function returns the sign of a number.
This function will return one of the following:
SIGN(number)
Round the number to 2 decimal places:
SELECT ROUND(235.415, 2) AS RoundValue;
The ROUND() function rounds a number to a specified number of decimal places.
Tip: Also look at the FLOOR() and CEILING() functions.
ROUND(number, decimals, operation)