TIME()

The TIME() function allows us to extract just the time portion of a time string, which consists of the hour, minute, and second (hh:mm:ss).

Syntax

SELECT TIME('2020-09-01 17:38:22');
-- 17:38:22

Example

For example, suppose there’s a bodega table with the following data:

SELECT TIME(order_date)
FROM bodega;

This would return the time for the order_date column.