SQL DATENAME() is a SQL Server function used to return the name or value of the specified datepart of the a date.
Date Function
SQL CONVERT
The SQL CONVERT() is a SQL Server function which is used to convert a data type to another data type in general. We can also use this function to convert a date/time expression to different formats, or convert a formatted date/time string to date expression.
SQL EXTRACT (Oracle Function)
The SQL EXTRACT() function is used to get a value (year, month, day, 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 Oracle.
SQL EXTRACT (MySQL Function)
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
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).
SQL DATE_SUB
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
MySQL DATE() function is used to get the date part of a date/time expression.
SQL DATE_FORMAT
SQL DATE_FORMAT() is a MySQL function which returns date/time in your requested format.
SQL CURTIME
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