SQL – MySQL DATE() Function
The MySQL DATE() function extracts the date part from a datetime expression.
SQL – MySQL DATEDIFF() Function
The MySQL DATEDIFF() function returns the number of days between two date values.
SQL – MySQL DATE_ADD() Function
The MySQL DATE_ADD() function adds a time/date interval to a date and then returns the date.
SQL – MySQL DATE_SUB() Function
The MySQL DATE_SUB() function subtracts a time/date interval from a date and then returns the date.
SQL – MySQL DAY() Function
The MySQL DAY() function returns the day of the month for a given date (a number from 1 to 31).
SQL – MySQL DAYNAME() Function
The MySQL DAYNAME() function returns the weekday name for a given date.
SQL – MySQL DAYOFMONTH() Function
The MySQL DAYOFMONTH() function returns the day of the month for a given date (a number from 1 to 31).
SQL – MySQL DAYOFWEEK() Function
The MySQL DAYOFWEEK() function returns the weekday index for a given date (a number from 1 – Sunday to 7 – Saturday).
SQL – MySQL DAYOFYEAR() Function
The MySQL DAYOFYEAR() function returns the day of the year for a given date (a number from 1 to 366).
SQL – MySQL EXP() Function
The MySQL EXP() function returns the natural logarithm e (2.718281…) raised to the power of the specified number.
SQL – MySQL FIELD() Function
The MySQL FIELD() function returns the index position of a case-insensitive value in a list of values.
SQL – MySQL FIND_IN_SET() Function
The MySQL FIND_IN_SET() function returns the position of a string within a list of strings.
SQL – MySQL FLOOR() Function
The MySQL FLOOR() function returns the largest integer value that is smaller than or equal to a number.
SQL – MySQL FORMAT() Function
The MySQL FORMAT() function formats a number to a format like “#,###,###.##”, rounded to a specified number of decimal places, and returns it as a string.
SQL – MySQL FROM_DAYS() Function
The MySQL FROM_DAYS() function returns a date from a numeric datevalue.
SQL – MySQL GREATEST() Function
The MySQL GREATEST() function returns the greatest value of the list of arguments.