The SQL EXTRACT() function is used to get a value (year, month, day, hour, minute, etc.) from a date/time expression. It’s supported by MySQL and Oracle, but the syntax is different. In this post we’ll discuss it’s syntax and example in MySQL.

SQL QUARTER is a MySQL function which also supported by Ingres database. It will return the quarter of a date expression as an integer (in the range of 1-4).

The SQL DATE_SUB is a mySql function, unlike SQL DATE_ADD function which add time value, SQL DATE_SUB will subtract time values (intervals) from a date value.

MySQL DATE() function is used to get the date part of a date/time expression.

SQL DATE_FORMAT() is a MySQL function which returns date/time in your requested format.

SQL CURTIME is a MySQL function which returns current time based on server system. Note: MySQL has 3 similar functions: SQL NOW() : return date and time SQL CURDATE(): returns date SQL CURTIME: returns time

SQL CURDATE is a MySQL function which returns current date based on server system. Note: MySQL has 3 similar functions: SQL NOW() : return date and time SQL CURDATE: returns date SQL CURTIME: returns time

The SQL DATE_ADD is a mySql function which is same as SQL ADDDATE(), it’s used to add time values (intervals) to a date value.