Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
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



Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 266 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?