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.
Author Archives: admin
SQL CHAR
SQL CHAR function is used to return a character of an int ASCII code.
SQL Hosting
SQL hosting is the hosting that provides the SQL database services. It has many SQL databases in the SQL hosting market, and the most popular are MySQL, MS SQL Server, MS Access and Oracle.
Continue reading
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 ASCII
SQL ASCII function is used to return ASCII code of a character, if the parameter is a string, it will return the ASCII code of the most left character.
ORACLE TO_DATE
Oracle To_date() is an SQL function which will convert a string to date. In SQL Server we could use SQL CONVERT function to convert a string to 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.
Continue reading
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.
Continue reading
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.
Continue reading
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).