MySQL LOCATE() Function

LOCALTIMESTAMP() Function in MySQL

Last Updated : 27 Nov, 2020

LOCALTIMESTAMP() function : This function in MySQL is used to return the current date and time in the format of "YYYY-MM-DD HH-MM-SS" (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric). Syntax :

LOCALTIMESTAMP
OR
LOCALTIMESTAMP()

Parameter : This method does not accept any parameters. Returns : It returns the current date and time. Example-1 : Getting current date and time "2020-11-25 07:57:09" in the format of "YYYY-MM-DD HH-MM-SS".

SELECT LOCALTIMESTAMP();

Output :

2020-11-25 07:57:09

Example-2 : Getting current date and time + 1 as "20201125075901" in the format of "YYYYMMDDHHMMSS.uuuuuu".

SELECT LOCALTIMESTAMP() + 1;

Output :

20201125075901

Example-3 : Getting current date and time "2020-11-25 08:11:55" in the format of "YYYY-MM-DD HH-MM-SS".

SELECT LOCALTIMESTAMP as CurrDateTime;

Output :

2020-11-25 08:11:55

Application : This function is used to return the current date and time.

MySQL LOCATE() Function

K

Kanchan_Ray

Improve

Article Tags :

Similar Reads

LOCALTIME() function in MySQL

LOCALTIME() function in MySQL is used to check current date and time value. It returns the value of current date and time in â€˜YYYY-MM-DD HH:MM:SSâ€™ format or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in string or numeric context. Syntax : LOCALTIME OR LOCALTIME() Paramet

LEAST() Function in MySQL

The LEAST() function in MySQL is a versatile tool that returns the smallest (minimum) value from a list of expressions. It can be used with numbers, strings, or even columns of data to find the minimum value according to their data type.In this article, We will learn about LEAST() Function in MySQL

MAKETIME() Function in MySQL

MAKETIME() function : This function in MySQL is used to create and return a time value based on specified hour, minute, and second value. In MySQL's TIME value limit is 838:59:59. Syntax : MAKETIME(hour, minute, second) Parameters : This method accepts three parameters as given below - hour : Specif

MySQL LOCATE() Function

MySQL LOCATE() function is used to find the position of a substring in a string. It returns the location of the first occurrence of the substring in the string. If the substring is not present in the string, then it will return 0. LOCATE() function in MySQL does not perform a case-sensitive search.

LEFT() Function in MySQL

The LEFT() function in MySQL is used to extract a specified number of characters from the left side of a given string. It uses its second argument to decide, how many characters it should return. Syntax: LEFT (str, len)Parameter: This function accepts two parameters as mentioned above and described

INSERT() function in MySQL

INSERT() : This function in MySQL is used for inserting a string within a string, removing a number of characters from the original string. Syntax : INSERT(str, pos, len, newstr) Parameters : This method accepts four parameter. str - Original string in which we want to insert another string. pos - T

LOG() Function in MySQL

LOG() function in MySQL is used to calculate the natural logarithm of a specific number. The number must be >0 Otherwise it will return NULL. Syntax : LOG(X) Parameter : This method accepts one parameter as mentioned above and described below : X : A number whose logarithm value we want to calcul

Mathematical functions in MySQL

Mathematical functions in MySQL are essential tools for performing a variety of numerical operations directly within SQL queries. These built-in functions enable users to execute calculations, manipulate numeric data, and perform statistical analysis efficiently. In this article, We will learn about

UTC_TIMESTAMP() function in MySQL

UTC_TIMESTAMP() function in MySQL is used to check current Coordinated Universal Time (UTC) date and time value. It returns the current UTC date and time value in YYYY-MM-DD HH:MM:SS or YYYYMMDDHHMMSS.uuu format, depending on whether the function is used in string or numeric context. Syntax : UTC_TI

LN() Function in MySQL

LN() function : It is the function in MySQL is used to calculate the natural logarithm of a specific number with base e . The number must be greater than 0, otherwise it will return NULL. Syntax : LN(X) Parameter : LN() function accepts one parameter as mentioned above in the syntax and described be