Quick Search:
 
 The Oracle PL/SQL SYSTIMESTAMP Function      [Return To Index] Jump to:  

Term: SYSTIMESTAMP

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:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org