SQL · Date and time functions

time()

Returns the time portion of a timestamp.

sqlRunnable example sql course

Syntax

time(timestring)

Example

Open in the lab

SELECT time('2026-11-01 09:30:00') AS at;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.