LOCALTIMESTAMP() Function Examples – MySQL

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

Here, we will take the MySQL database table related examples following below:

  • How to insert current timestamp(date and time) in the database table.
  • Using PHP insert current date time in the MySQL database table column

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.

If you have any questions or thoughts to share, use the comment form below to reach us.

Spread the love

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *