Question

explain date and time function two examples ​

Answer 1

MySQL functions are mainly classified into two types.

• Single-row functions
• Multiple-row functions

Single-row functions are those functions that operate on a single row and return a single value.

Multiple-row functions are those functions that operate on multiple rows and return a single value.

Single-row functions are again classified into three types:

• Numeric
• String
• Date

Date functions are those functions that are related to date and time.

Two examples of date functions could be:

• curdate()
• now()

SELECT CURDATE(); - returns the current date.

SELECT NOW(); - returns both the current date and time.