Tutorial Gateway

MySQL Time Function

by

MySQL Time function is one of the Date Function, which is useful to extract the Time part from the given time or DateTime.

In this study, we show you how to use this MySQL Time function to extract the time value from the given expression with an example.

MySQL Time Syntax

The basic syntax of the Time() Function in MySQL is as shown below:

TIME(Time or DateTime or expression);

MySQL Time function Example

The following queries help you understand the use of this Time function. Here, we are extracting the Time value from the time expression and different Datetime expressions.

SELECT TIME('10:12:34');

SELECT TIME('2016-05-19 11:14:34');

SELECT TIME('2016-05-19 16:14:39');

OUTPUT

MySQL Time Function 1

Time Function Example 2

In this example, we are extracting the Time value from the current date and time returned by the Now, UTC_TIME function, and UTC_TIMESTAMP function.

SELECT NOW(), TIME(NOW());

SELECT UTC_TIME(), TIME(UTC_TIME());

SELECT UTC_TIMESTAMP(), TIME(UTC_TIMESTAMP());

OUTPUT

MySQL Time Function 2

Here, we are trying to return the Time value from String DateTime format

SELECT NOW(), TIME(NOW() + 10);

SELECT NOW(), TIME(NOW() + 10);

SELECT UTC_TIMESTAMP(), TIME(UTC_TIMESTAMP()+10);

OUTPUT

MySQL Time Function 3

Here, we are trying to return the Time value from different DateTime or time formats. Within the last statement, we used the zero Time part.

SELECT TIME('2016-05-19 11:14:34.111234');

SELECT TIME('11:14:74.111234');

SELECT TIME('00:00:00');

OUTPUT

MySQL Time Function 4

MySQL Time Example 3

In this example, we show how to use this Time function on table data. Here, we are returning the Time value from the Hire Date column.

SELECT EmpID,
       FirstName,
       LastName,
       Occupation,
       YearlyIncome,
       Sales,
       HireDate,
       TIME(HireDate)
 FROM `MySQL Tutorial`.customer;

OUTPUT

MySQL Time Function 5