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 Server
The Difference Among char, nchar, varchar, nvarchar in MS SQL Server
In MS SQL Server, there are some data types of string, like char, nchar, varchar, nvarchar. What’s the difference among them?
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 DATENAME
SQL DATENAME() is a SQL Server function used to return the name or value of the specified datepart of the a date.
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 DATEDIFF
The SQL DATEDIFF() function is used to get the date/time difference of 2 date expressions. It is supported by both SQL Server and MySQL, but the syntax is different.
SQL DATEADD
The SQL DATEADD() function is used to add or subtract a time interval to a date.