SQL Functions

SQL Server Function includes Aggregate functions, Conversion functions, Analytics functions, Date functions, Logical Functions, String funcitons, and System functions

SQL DATEDIFF()

SQL DATEDIFF() function is used to calculate the difference between two dates.

SQL DATEADD()

SQL DATEADD() function adds a number to a specified date part of an input date and returns the modified date.

SQL TRIM()

SQL Server TRIM() function is used to remove both Leading and Trailing spaces from any given string It was introduced in SQL Server 2017 version… Read More »SQL TRIM()

SQL UPPER()

SQL UPPER() function converts all the characters in a string into uppercase.

SQL CURRENT_TIMESTAMP

SQL CURRENT_TIMESTAMP function returns the current date and time .

SQL GETDATE()

SQL GETDATE() function returns the current date and time.

SQL CHARINDEX()

SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.

SQL SUBSTRING()

SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.

SQL DATALENGTH Function

SQL DATALENGTH() function is used to return the number of bytes used to represent a given string.

SQL Server RTRIM()

SQL Server RTRIM() function is used to trim trailing characters from a character string.

SQL Server LTRIM()

SQL Server LTRIM() function is used to trim leading characters from a character string.

SQL SERVER REPLACE

SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .

SQL LOWER()

SQL LOWER() function converts all the characters in a string into lowercase.

SQL LEN()

SQL LEN() function is used to count the number or length of character in given string. It returns integer value always and null for empty string.

SQL EOMONTH()

SQL EOMONTH() function is a date function , it returns the last day of the month of a specified date, with an optional offset.