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:
order_id | item | price | quantity | order_date |
---|---|---|---|---|
1 | Donut | 2.49 | 2 | 2022-08-16 08:04:23 |
2 | Cookie | 0.99 | 3 | 2022-08-16 09:43:00 |
3 | Donut | 2.49 | 1 | 2022-08-16 11:25:12 |
4 | Egg Sandwich | 7.99 | 1 | 2022-08-17 11:45:41 |
5 | Ice Coffee | 3.99 | 2 | 2022-08-17 12:18:50 |
SELECT TIME(order_date)FROM bodega;
This would return the time for the order_date
column.
TIME(order_date) |
---|
08:04:23 |
09:43:00 |
11:25:12 |
11:45:41 |
12:18:50 |