MINUTE
The function MINUTE returns an integer in the range of 0 to 59. This integer represent the count of minutes since beginning of the hour. If you use it with a date data type then it return ever 0.
| SQL Syntax: |
MINUTE( time ) | |
| Time: |
Any date expression. | |
| Escape Syntax: |
{fn MINUTE( time )} | |
| Return Type: |
INT | |
Examples:
SELECT MINUTE({ts '2006-01-01 11:25:59'}), {fn minute({t '2:12:34'})}Returns: 25, 12
see also:
SQL Date Time Functions
HOUR