Below given the SQL functions
- SQL NOW()– Returns the current date and time
- SQL CURDATE()– Returns the current date
- SQL CURTIME()– Returns the current time
- SQL DATE()– Extracts the date part of a date or date/time expression
- SQL EXTRACT()- Returns a single part of a date/time
- SQL DATE_ADD()– Adds a specified time interval to a date
- SQL DATE_SUB() -Subtracts a specified time interval from a date
- SQL DATEDIFF()– Returns the number of days between two dates
- SQL DATE_FORMAT()– Displays date/time data in different formats
- SQL NULL Functions – We can use these function to manage the null values
- SQL avg() – returns the average value of a numeric column
- SQL count() – returns the number of rows
- SQL first() – returns the first value of the selected column.
- SQL last() – returns the last value of the selected column.
- SQL max() – returns the largest value of the selected column.
- SQL min() – returns the smallest value of the selected column.
- SQL sum() – returns the total sum of a numeric column.
- SQL Group By – should be added with all aggregate functions
- SQL ucase() – converts the value of a field to uppercase.
- SQL lcase() – converts the value of a field to lowercase.
- SQL mid() – used to extract characters from a text field
- SQL len() – returns the length of the value in a text field.
- SQL round() – used to round a numeric field to the number of decimals specified.