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


100% pure Java DBMS
Mirror Site