w3resource

Oracle SYSTIMESTAMP function

Description

The SYSTIMESTAMP function is used to get the system date, including fractional seconds and time zone, of the system on which the database resides.

Syntax:

SYSTIMESTAMP

Parameters:

No parameters or arguments.

Return Type:

The return type is TIMESTAMP WITH TIME ZONE.

Pictorial Presentation

Pictorial Presentation of Oracle SYSTIMESTAMP function

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)



Share this Tutorial / Exercise on : Facebook and Twitter