SQL Tutorial - Learn SQL Online

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.

SQL Functions String Function Leave a comment

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 Functions Oracle Leave a comment

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 Functions Date Function, SQL Server Leave a comment

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 Functions Date Function, Oracle Leave a comment

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 Functions Date Function, MySQL Leave a comment

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 Functions Date Function, MySQL Leave a comment

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.

SQL Functions Date Function, MySQL Leave a comment