Quick Search:
 
 The Oracle PL/SQL MINUTE Keyword      [Return To Index] Jump to:  

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



Related Links:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org