CURTIME() function in MySQL
CURTIME() function in MySQL is used to check the current time. It returns the current time as a value in ‘hh:mm:ss’ or ‘hhmmss’ format, depending on whether the function is used in a string or numeric context.
Syntax :
CURTIME(fsp)
Parameters :
This method accepts only one parameter.
fsp –
It specifies the returned fractional seconds precision. If the user omits the precision argument, the result will exclude precision.
Returns :
It returns the current time.
Example-1:
Getting the current time using CURTIME Function.
SELECT CURTIME() as Curr_time ;
Output :
CURR_TIME |
---|
13:06:54 |
Example 2:
Getting the current time using CURTIME Function with precision is set to 3.
SELECT CURTIME(3) as Curr_time ;
Output :
CURR_TIME |
---|
13:09:06.109 |
Example-3:
Getting the current time using CURTIME Function in numeric format.
SELECT CURTIME() + 0 as Curr_time ;
Output :
CURR_TIME |
---|
131014 |
Example-4:
The CURTIME function can be used to set the value of columns. To demonstrate create a table named DeliveryDetails.
CREATE TABLE DeliveryDetails ( DeliveryId INT AUTO_INCREMENT, ProductId INT NOT NULL, ProductName VARCHAR(20) NOT NULL, Delivered_At TIME NOT NULL, Delivered_On DATE NOT NULL, PRIMARY KEY(DeliveryId) );
Here, we will use CURDATE and CURTIME function when a delivery will be completed. The value in the Delivered_At column will be the value given by CURTIME and the value in the Delivered_On column will be the value given by the CURDATE Function.
INSERT INTO DeliveryDetails(ProductId, ProductName, Delivered_At, Delivered_On) VALUES (12345, 'Dell Latitude', CURTIME(), CURDATE() );
Now, checking the DeliveryDetails table :
SELECT * FROM DeliveryDetails;
Output :
DELIVERYID | PRODUCTID | PRODUCTNAME | DELIVERED_AT | DELIVERED_ON |
---|---|---|---|---|
1 | 12345 | Dell Latitude | 13:17:22 | 2020-11-20 |
Contact Us