TIME

Description

The TIME function get the Datetime value's time part.

Syntax

TIME(<datetime>)

Parameters

Parameter	Description
<datetime>	The datetime value.

Return Value

Returns a TIME type value

Example

SELECT TIME('2025-1-1 12:12:12');

mysql> 
+---------------------------+
| time('2025-1-1 12:12:12') |
+---------------------------+
| 12:12:12                  |
+---------------------------+