MySQL TIME() Function

Extract the time part from a time expression:

SELECT TIME("19:30:10");

Definition and Usage

The TIME() function extracts the time part from a given time/datetime.

Note: This function returns "00:00:00" if expression is not a datetime/time, or NULL if expression is NULL.

TIME( expression)

Parameter	Description
expression	Required. The time/datetime to extract the time from

Works in:	From MySQL 4.0

Extract the time part from the datetime expression:

SELECT TIME("2017-08-15 19:30:10");

Extract the time part from the datetime expression:

SELECT TIME("2017-08-15 19:30:10.000001");

Extract the time part from NULL:

SELECT TIME(NULL);