SYSTIMESTAMP

SYSTIMESTAMP returns the system date, including fractional seconds and time zone, of the system on which the database resides.

Return Value

TIMESTAMP WITH TIME ZONE

Syntax

SYSTIMESTAMP

Example

SYSTIMESTAMP returns a value such as 13-AUG-06 05.28.10.385799 PM -08:00.

Copyright © 2003, 2007, Oracle. All rights reserved.