Question

Write Queries using Date and time Functions.​

Answer 1

Answer:

Examples of Date Time Functions in SQL

NOW( ) in SQL. Syntax: SELECT NOW(); ...

CURDATE( ) in SQL. Syntax: SELECT CURDATE(); ...

CURTIME( ) in SQL. Syntax: SELECT CURTIME(); ...

DATE( ) in SQL. Syntax: SELECT DATE(columnName),columnName2 FROM tableName; ...

EXTRACT( ) in SQL. ...

DATE_ADD( ) ...

DATE_SUB( ) ...

DATEDIFF( )

Explanation: