CURRENT_TIMESTAMP() function in MySQL

CURRENT_TIMESTAMP() function in MySQL is used to check the current date and time value. In MySQL function, CURRENT_TIMESTAMP is needed when you need to keep a record of the exact time of delivery which is helpful in improving the services and functionalities of any organization. The format of this function is in the form of the current date and time value in YYYY-MM-DD HH:MM: SS or YYYYMMDDHHMMSS.uuu format, depending on whether the function is used in a string or numeric context.

Let’s consider an example for a better understanding if you have bought or like you have used courier service then you will see they will provide you a unique ID to keep update and trace your product location is in case of courier and In case of buying you will get the update by where exactly your product is and when you will get and the expected date etc. all the information you will get. In both cases, CURRENT_FUNCTION is needed to keep track of the current time of delivery location.

Syntax :

CURRENT_TIMESTAMP
OR
CURRENT_TIMESTAMP()

Parameter :
This method does not accept any parameter.

Returns :
It returns the current date and time value.

Example-1 :
Getting the current date and time using CURRENT_TIMESTAMP Function.

SELECT CURRENT_TIMESTAMP 
as CurrDateAndTime ;

Output :

CURRDATEANDTIME
2020-10-13 14:40:10

Example-2 :
Getting the current date and time using CURRENT_TIMESTAMP  Function in numeric format.

SELECT CURRENT_TIMESTAMP + 0 
as CurrDateAndTime ;

Output :

CURRDATEANDTIME
20201013144123

Example-3 :
The CURRENT_TIMESTAMP function can be used to set value of columns. To demonstrate create a table named DeliveryDetails.

CREATE TABLE Details_of_Delivery (
Delivery_Id INT AUTO_INCREMENT,
Product_Id INT NOT NULL,
Product_Name VARCHAR(20) NOT NULL,
Delivered_At_time TIMESTAMP NOT NULL,
PRIMARY KEY(Delivery_Id)
);

Here, we will use the CURRENT_TIMESTAMP function when a delivery will be completed. The value in the Delivered_At_time column will be the value given by the CURRENT_TIMESTAMP Function.

INSERT INTO  
Details_of_Delivery(Product_Id, Product_Name, Delivered_At_time)
VALUES
(990067, 'Acer Nitro', CURRENT_TIMESTAMP );
INSERT INTO  
Details_of_Delivery(Product_Id, Product_Name, Delivered_At_time)
VALUES
(990068, 'Dell', CURRENT_TIMESTAMP );

Now, checking the Details_of_Delivery table.

SELECT * FROM Details_of_Delivery;

Output :

DELIVERY_ID	PRODUCT_ID	PRODUCT_NAME	DELIVERED_AT_time
1	990067	Acer Nitro	2020-10-13 14:43:48
2	990068	Dell	2020-10-13 14:45:48