Write Queries using Date and time Functions.
Answers
Answered by
5
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:
Similar questions