Term: MINUTE

Definition:
In Oracle the datetime field MINUTE is available with all the DATETIME data types and INTERVAL data types. Oracle datetime data types are DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. The value range for MINUTE field is 0-59. It can be extracted from a datetime value using EXTRACT function.

Example Usage

SELECT EXTRACT(MINUTE FROM SYSTIMESTAMP ) A

FROM DUAL

/



         A

----------

         5

• Oracle Conversion Functions: Examples using MINUTE
• Oracle Timestamps: MINUTE