Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL SECOND Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: SECOND

Definition:
In Oracle PL/SQL, SECOND refers to a datetime field which is available with all the DATETIME data types i.e. DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. For the SECOND field, valid values ranges from 0 to 59.9(N). Here 9(n) represents fractional seconds, but this is not applicable for DATE. It can be extracted from DATE values using the EXTRACT function.

Example Usage:

SELECT EXTRACT(SECOND FROM TO_TIMESTAMP('15-JAN-2011 10:00:56','DD-MON-YYYY HH24:MI:SS')) SECOND
FROM DUAL;

SECOND
----------
56


Related Links:

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