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:
