Skip to content

SQL Tutorial - Learn SQL Online

  • Home
  • SQL Syntax
  • SQL Functions
  • Table Manipulation
  • SQL Advanced

MySQL

SQL REVERSE

December 11, 2011 by admin

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.

Read more

Categories SQL Functions Tags MySQL, Oracle, SQL Server, String Function Leave a comment

SQL LEFT Function

December 4, 2011 by admin

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.

Read more

Categories SQL Functions Tags MySQL, SQL Server, String Function Leave a comment

SQL SPACE

December 2, 2011 by admin

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.

Read more

Categories SQL Functions Tags MySQL, SQL Server, String Function Leave a comment

SQL EXTRACT (MySQL Function)

November 7, 2011November 7, 2011 by admin

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.

Read more

Categories SQL Functions Tags Date Function, MySQL Leave a comment

SQL QUARTER

November 5, 2011 by admin

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

Read more

Categories SQL Functions Tags Date Function, MySQL Leave a comment

SQL DATE_SUB

November 2, 2011 by admin

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.

Read more

Categories SQL Functions Tags Date Function, MySQL Leave a comment

MySQL DATE Function

October 29, 2011 by admin

MySQL DATE() function is used to get the date part of a date/time expression.

Read more

Categories SQL Functions Tags Date Function, MySQL Leave a comment

SQL DATE_FORMAT

October 2, 2011 by admin

SQL DATE_FORMAT() is a MySQL function which returns date/time in your requested format.

Read more

Categories SQL Functions Tags Date Function, MySQL 1 Comment

SQL CURTIME

September 30, 2011 by admin

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

Read more

Categories SQL Functions Tags Date Function, MySQL Leave a comment

SQL CURDATE

September 30, 2011September 26, 2011 by admin

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

Read more

Categories SQL Functions Tags Date Function, MySQL Leave a comment
Post navigation
Older posts
Page1 Page2 Next →

Recent Posts

  • SQL FOREIGN KEY Constraint
  • SQL UNIQUE Constraint
  • SQL PRIMARY KEY Constraint
  • SQL DEFAULT Constraint
  • SQL NOT NULL Constraint
  • SQL Create Table
  • ORACLE TO_CHAR
  • SQL REVERSE
  • The Difference Among char, nchar, varchar, nvarchar in MS SQL Server
  • SQL LEFT Function
  • SQL SPACE
  • SQL CHAR
  • SQL Hosting
  • SQL DATENAME
  • SQL ASCII

Categories

  • SQL Advanced (6)
  • SQL Functions (44)
  • SQL Syntax (29)
  • Table Manipulation (6)
© 2022 SQL Tutorial - Learn SQL Online • Built with GeneratePress