Oracle SYSTIMESTAMP function

Description

The SYSTIMESTAMP function in Oracle retrieves the current system date, including fractional seconds and time zone, of the system on which the database resides.

Uses of Oracle SYSTIMESTAMP Function

• Retrieving System Date and Time: Get the current date and time with high precision, including time zone.


• Timestamping Events: Use SYSTIMESTAMP to log events with accurate timestamps in applications and databases.


• Time Zone Awareness: Handle time zone calculations and conversions by accessing system timestamps that include time zone data.


• Monitoring and Auditing: Facilitate tracking and auditing by recording the exact time of transactions and changes.

Syntax:

SYSTIMESTAMP

Parameters:

No parameters or arguments.

Return Type:

The return type is TIMESTAMP WITH TIME ZONE.

Pictorial Presentation

Examples: Oracle SYSTIMESTAMP function

The following example returns the system timestamp:

SQL> SELECT SYSTIMESTAMP FROM DUAL;

Sample Output:

SYSTIMESTAMP
------------------------------------------------
01-MAY-15 03.45.45.761000 PM +05:30

Previous: SYSDATE
Next: TO_CHAR(datetime)