SQL – SQL Server DATEDIFF() Function
The SQL Server DATEDIFF() function returns the difference between two dates.
SQL – SQL Server DATEFROMPARTS() Function
The SQL Server DATEFROMPARTS() function returns a date from the specified parts (year, month, and day values).
SQL – SQL Server DATENAME() Function
The SQL Server DATENAME() function returns a specified part of a date as a string value.
SQL – SQL Server DATEPART() Function
The SQL Server DATEPART() function returns a specified part of a date as an integer value.
SQL – SQL Server DAY() Function
The SQL Server DAY() function returns the day of the month (from 1 to 31) for a specified date.
SQL – SQL Server DEGREES() Function
The SQL Server DEGREES() function converts a value in radians to degrees.
SQL – SQL Server DIFFERENCE() Function
The SQL Server DIFFERENCE() function compares two SOUNDEX values, and returns an integer.
SQL – SQL Server EXP() Function
The SQL Server EXP() function returns the natural logarithm e (2.718281…) raised to the power of the specified number.
SQL – SQL Server FLOOR() Function
The SQL Server FLOOR() function returns the largest integer value that is smaller than or equal to a number.
SQL – SQL Server FORMAT() Function
The SQL Server FORMAT() function formats a value with the specified format (and an optional culture in SQL Server 2017).
SQL – SQL Server GETDATE() Function
The SQL Server GETDATE() function returns the current database system date and time, in a “YYYY-MM-DD hh:mm:ss.mmm” format.
SQL – SQL Server GETUTCDATE() Function
The SQL Server GETUTCDATE() function returns the current database system UTC date and time, in a “YYYY-MM-DD hh:mm:ss.mmm” format.
SQL – SQL Server IIF() Function
The SQL Server IIF() function returns a value if a condition is TRUE, or another value if a condition is FALSE.
SQL – SQL Server ISDATE() Function
The SQL Server ISDATE() function checks an expression and returns 1 if it is a valid date, and 0 if it is NOT a valid date.
SQL – SQL Server ISNULL() Function
The SQL Server ISNULL() function returns a specified value if the expression is NULL, and the expression itself if the expression is NOT NULL.
SQL – SQL Server ISNUMERIC() Function
The SQL Server ISNUMERIC() function tests whether an expression is numeric, and returns 1 if the expression is numeric and 0 if it is not numeric.
SQL – SQL Server LEFT() Function
The SQL Server LEFT() function extracts a number of characters (starting from left) from a string.
SQL – SQL Server LEN() Function
The SQL Server LEN() function returns the length of a string. Trailing spaces (after) are not included, but leading spaces (before) are included.
SQL – SQL Server LOG() Function
The SQL Server LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.
SQL – SQL Server LOG10() Function
The SQL Server LOG10() function returns the natural logarithm of a number greater than 0 to base 10.