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).
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
