SECOND() Function in MySQL

MySQL | VERSION( ) Function

Last Updated : 19 Nov, 2019

The MySQL Version() function is used for returning the current version of the MySQL database. This function uses the utf8 character set. Generally, there is a suffix returned after the version number. The Version() function does not require any parameter to be passed.

Syntax:

VERSION()

Parameters Used:
It does not require any parameter or argument to be passed.

Return Value:
The MySQL Version() function returns the version of the MySQL database as a string.

Supported Versions of MySQL:

MySQL 5.7
MySQL 5.6
MySQL 5.5
MySQL 5.1
MySQL 5.0
MySQL 4.1
MySQL 4.0
MySQL 3.23

Example: Implementing Version() function in MySQL.

SELECT VERSION();

Output:

5.7.26-0ubuntu0.18.04.1

SECOND() Function in MySQL

S

Shubrodeep Banerjee

Improve

Article Tags :

Similar Reads

SIGN() Function in MySQL

SIGN() function in MySQL is used to return the sign of the given number. It returns 1 if the number is positive, -1 if the number is negative and 0 for zero. Syntax : SIGN(X) Parameter : SIGN() function accepts one parameter as input and will give you the results in values like Positive(+1),Negative

MySQL | SESSION_USER( ) Function

The MySQL SESSION_USER() function is used for returning the current user name and host name for the MySQL connection being used by the user. The SESSION_USER() function does not require any parameter to be passed. The user name returned by the SESSION_USER() function is the name of the user-specifie

PLSQL | SIN Function

The PLSQL SIN function is used to return the sine of a numeric value. The SIN function accepts one parameter which is the number whose sine needs to be calculated. The SIN function returns a value of the numeric data type. This function takes as an argument any numeric data type as well as any non-n

MySQL | SHA1( ) Function

The MySQL SHA1() function is used for encrypting a string using the SHA-1 technique. The SHA1 stands for secure hash algorithm and it produces a 160-bit checksum for a user inputted string. The MySQL SHA1() function returns NULL if the string passed as an argument is a NULL string. The SHA1() functi

SECOND() Function in MySQL

SECOND() function in MySQL is used to return the second portion of a specified time or date-time value. The first parameter in this function will be the date/Date Time. This function returns the seconds from the given date value. The return value (seconds) will be in the range of 0 to 59. In this fu

PLSQL | SIGN Function

The PLSQL SIGN function is used for returning a value which indicates the sign of a number. The SIGN function accepts one parameter which is the number whose sign needs to be known. The SIGN function returns a value of the numeric data type. This function takes as an argument any numeric data type a

PLSQL | SINH Function

The PLSQL SINH function is used to return the hyperbolic sine of a numeric value. The SINH function accepts one parameter which is the number whose hyperbolic sine needs to be calculated. The SINH function returns a value of the numeric data type. This function takes as an argument any numeric data

YEAR() Function in MySQL

YEAR() function in MySQL is used to find year from the given date. If the date is NULL, the YEAR() function will return NULL. Otherwise, it returns value range from 1000 to 9999. Syntax : YEAR(date) Parameter : This method accepts one parameter as mentioned above and described below : date : The dat

SQL | String functions

SQL String Functions are powerful tools that allow us to manipulate, format, and extract specific parts of text data in our database. These functions are essential for tasks like cleaning up data, comparing strings, and combining text fields. Whether we're working with names, addresses, or any form

PLSQL | VSIZE Function

The PLSQL VSIZE function is used for returning the number of bytes in the internal representation of an expression. The PLSQL accepts only one parameter which specifies the expression. Generally, the VSIZE function returns a numeric value but if the expression is Null then this function returns null