MySQL LOCALTIMESTAMP() Function

MySQL LOCALTIMESTAMP() function; In this tutorial, we are going to show you how to use MySQL LOCALTIMESTAMP() function with the help of its syntax and various examples.

Mysql LOCALTIMESTAMP() Function

LOCALTIMESTAMP the function is used to returns the current date and time in mysql.

Note: This function is a synonym for to the MySQL NOW() function. The LOCALTIMESTAMP function is returned in YYYY-MM-DD HH: MM: SS ‘or YYYYMMDDHHMMSS format values, depending on whether the function is used in a string or numerical context.

Syntax

The basic syntax of this function is:

 LOCALTIMESTAMP
==========================OR===============
 LOCALTIMESTAMP(optional)

Here (optional) the parameter specifies the partial second precision for the return value.

Example-1

Let’s take a basic example of a LOCALTIMESTAMP function is

SELECT LOCALTIMESTAMP;

Output-1

+---------------------+
| LOCALTIMESTAMP      |
+---------------------+
| 2019-07-19 11:35:45 |
+---------------------+

Example-2

We take another example using the LOCALTIMESTAMP() function in a numeric context.

SELECT LOCALTIMESTAMP() + 0;

Output-2

+-------------------------+
| LOCALTIMESTAMP() + 0 |
+-------------------------+
|          20190719113258 |
+-------------------------+

Example-3

We take example 3 using LOCALTIMESTAMP() function and NOW() function. It will return the same result(date and time)

SELECT LOCALTIMESTAMP()
       NOW();

Output-

+-------------------------+-------------------------+ 
| LOCALTIMESTAMP()     |            NOW()        | 
+-------------------------+-------------------------+  
|     2019-07-19 11:35:45 |    2019-07-19 11:35:45  | 
+-------------------------+-------------------------+

Example-3

Following below is the example of how to insert the current date into a DATETIME Field in a MySQL Database using LOCALTIMESTAMP() of MySQL.

INSERT INTO table_name SET column = LOCALTIMESTAMP

===============================OR============================

INSERT INTO test (created_at) VALUE (LOCALTIMESTAMP());

Example-4

Following below is the example of how to insert the current date into a DATETIME column in a MySQL Database using LOCALTIMESTAMP() of PHP MySQL.

In PHP, a better / faster / cleaner way of doing things is using LOCALTIMESTAMP, which is a built-in MySQL function.

<?php   
        $query = "INSERT INTO table_name SET column_name = LOCALTIMESTAMP";   
        $sqlQuery = mysql_query($query) or die(mysql_error()); 
?>

Conclusion

Here, you have learned how to use MySQL LOCALTIMESTAMP () function with various examples.

MySQL LOCALTIMESTAMP() Function