{"id":550,"date":"2017-08-07T13:30:04","date_gmt":"2017-08-07T06:30:04","guid":{"rendered":"https:\/\/oracletutorial.com\/?page_id=550"},"modified":"2023-10-05T00:17:42","modified_gmt":"2023-10-05T07:17:42","slug":"oracle-systimestamp","status":"publish","type":"page","link":"https:\/\/www.oracletutorial.com\/oracle-date-functions\/oracle-systimestamp\/","title":{"rendered":"Oracle SYSTIMESTAMP"},"content":{"rendered":"\n

The Oracle SYSTIMESTAMP<\/code> function returns a TIMESTAMP WITH TIME ZONE<\/a><\/code> value that represents the system date and time including fractional seconds and time zone.<\/p>\n\n\n\n

Syntax #<\/a><\/h2>\n\n\n\n

The Oracle SYSTIMESTAMP<\/code> function accepts no argument:<\/p>\n\n\n

SYSTIMESTAMP<\/code><\/span><\/pre>\n\n\n
Return Value #<\/a><\/h2>\n\n\n\n
The Oracle SYSTIMESTAMP<\/code> function returns a TIMESTAMP WITH TIME ZONE<\/code> value that represents the system date.<\/p>\n\n\n\n
Examples #<\/a><\/h2>\n\n\n\n
The following statement shows the returned value of the SYSTIMESTAMP<\/code> function:<\/p>\n\n\n
SELECT<\/span>\n  SYSTIMESTAMP\nFROM<\/span>\n  dual;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the result:<\/p>\n\n\n
07-AUG-17 01.08.16.408000000 PM -07:00\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span>\n  TO_CHAR(SYSTIMESTAMP,'DD-MON-YYYY HH24:MI:SS.FF2 TZH:TZM'<\/span>)\nFROM<\/span>\n  dual; \n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The output is a character string with the following format:<\/p>\n\n\n
07-AUG-2017 13:24:13.44 -07:00<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Noted that we used FF2<\/code> to format the timestamp with 2 digits for fractional second precision.<\/p>\n\n\n\n
In this tutorial, you have learned how to use the Oracle SYSTIMESTAMP<\/code> function to get a TIMESTAMP WITH TIME ZONE<\/code> value that represents the system date and time including fractional seconds and time zone.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t
To specify the value for fractional second argument e.g., 2-digit, you use the TO_CHAR()<\/code><\/a> function as follows:<\/p>\n\n\n