Example
SELECT TIME("19:30:10");Definition and Usage
The TIME() function extracts the time part from a given time/datetime.
Note
This function returns "00:00:00" if expression is not a datetime/time, or NULL if expression is NULL.
Syntax
TIME(
expression
)Parameter Values
| Parameter | Description |
|---|---|
| expression | Required. The time/datetime to extract the time from |
Technical Details
| Works in: | From MySQL 4.0 |
|---|