SQL – MySQL WEEK() Function
The MySQL WEEK() function returns the week number for a given date (a number from 0 to 53).
SQL – MySQL WEEKDAY() Function
The MySQL WEEKDAY() function returns the weekday number for a given date.
SQL – MySQL WEEKOFYEAR() Function
The MySQL WEEKOFYEAR() function returns the week number for a given date (a number from 1 to 53).
SQL – MySQL YEAR() Function
The MySQL YEAR() function returns the year part for a given date (a number from 1000 to 9999).
SQL – MySQL YEARWEEK() Function
The MySQL YEARWEEK() function returns the year and week number (a number from 0 to 53) for a given date.
SQL – SQL Server ABS() Function
The SQL Server ABS() function returns the absolute value of a number.
SQL – SQL Server ACOS() Function
The SQL Server ACOS() function returns the arc cosine of a specified number between -1 and 1.
SQL – SQL Server ASCII() Function
The SQL Server ASCII() function returns the ASCII value for the specified character.
SQL – SQL Server ASIN() Function
The SQL Server ASIN() function returns the arc sine of a specified number between -1 and 1.
SQL – SQL Server ATAN() Function
The SQL Server ATAN() function returns the arc tangent of a number.
SQL – SQL Server ATN2() Function
The SQL Server ATN2() function returns the arc tangent of two numbers.
SQL – SQL Server AVG() Function
The SQL Server AVG() function returns the average value of an expression (NULL values are ignored).
SQL – SQL Server CAST() Function
The SQL Server CAST() function converts a value of any type into a specified datatype.
SQL – SQL Server CEILING() Function
The SQL Server CEILING() function returns the smallest integer value that is larger than or equal to a number.
SQL – SQL Server CHAR() Function
The SQL Server CHAR() function returns the character based on the ASCII code specified.
SQL – SQL Server CHARINDEX() Function
The SQL Server CHARINDEX() function searches for a substring in a string, and returns the position. If the substring is not found, this function returns 0.
SQL – SQL Server COALESCE() Function
The SQL Server COALESCE() function returns the first non-null value in a list.
SQL – SQL Server CONCAT() Function
The SQL Server CONCAT() function adds two or more strings together.
SQL – SQL Server Concat With +
The SQL Server + operator allows you to add two or more strings together.
SQL – SQL Server CONVERT() Function
The SQL Server CONVERT() function converts a value of any type into a specified datatype.