Definition:
In Oracle PL/SQL, SYSTIMESTAMP is the built in function which returns the current database system date including fractional seconds and region time zone i.e. TIMESTAMP WITH TIME ZONE format.
Example Syntax:
SYSTIMESTAMP
Example Usage:
The SQL below shows the SYSTIMESTAMP value for the current database.
SQL> SELECT SYSTIMESTAMP FROM DUAL;
SYSTIMESTAMP
-------------------------------------------------
27-JAN-11 03.04.52.954000 PM +05:30
If we compare the output of SYSDATE and SYSTIMESTAMP, you can see the difference in fractional seconds of the output:
SELECT sysdate FROM DUAL
UNION ALL
SELECT systimestamp FROM DUAL
SYSDATE
----------------------------------------
27-JAN-11 03.10.20.000000 PM +05:30
27-JAN-11 03.10.20.304000 PM +05:30
Related Code Snippets:
