MINUTE()

Documentation

VoltDB Home » Documentation » Using VoltDB
< previoustable of contentsnext >

MINUTE()

MINUTE() — Returns the minute of the hour as an integer value.

Synopsis

MINUTE( timestamp-value )

Description

The MINUTE() function returns an integer value between 0 and 59 representing the minute of the hour in a timestamp value. This function produces the same result as using the MINUTE keyword with the EXTRACT() function.

Examples

The following example uses the HOUR(), MINUTE(), and SECOND() functions to return the time portion of a TIMESTAMP value in a formatted string.

SELECT eventname,
   CAST(HOUR(starttime) AS VARCHAR) || ' hours, ' ||
   CAST(MINUTE(starttime) AS VARCHAR) || ' minutes, and ' ||
   CAST(SECOND(starttime) AS VARCHAR) || ' seconds.' 
   AS timestring FROM event;
< previoustable of contentsnext >