Quick Search:


	CODE Oracle PL/SQL Code Library


	FORUM Oracle Discussion & Chat

The Oracle PL/SQL MINUTE Keyword [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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