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.
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 SPACE() function is used to return space characters, the number of the characters is indicated by the interger parameter. It is supported by MySQL and MS SQL Server, but not Oracle.
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).
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.