Page History
...
HOUR returns the hour (0 - 23) from a timestamp. MINUTE returns the minute (0 - 59). MONTH returns the month (1 - 12). YEAR returns the year from a timestamp.
Example
Code Block |
---|
SELECT HOUR('2001-02-03 04:05:06') FROM Employee |
Example
SELECT MINUTE('2001-02-03 04:08:06') FROM Employee
...