Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 

...