SQL REVERSE function is used to return reverse of a string. It’s supported by MS SQL Server, MySQL. Oracle supports it too, but maybe not in the documents.
MySQL
SQL LEFT Function
SQL LEFT() function is used to get left part of a string with the length of specified number. It is supported by MySQL, MS SQL Server, Access, but not by 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