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

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 50 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?