SQL Functions
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.
Beginner's Guide....