MySQLDate/Time FunctionsTIME
DATE

TIMEDate/Time Functions

YEAR

Extracts the time part from a date/time expression.

Syntax

TIME(expr)

Example

Enter values below to update the example in real time.

order_id
created_at
order_time
orders
SELECT order_id, TIME(created_at) AS order_time
FROM orders;