Skip Headers
Oracle® OLAP Expression Syntax Reference
Release 11.2

Part Number E23381-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP returns the current date and time in the session time zone. The time zone offset identifies the current local time of the session.

Return Value

TIMESTAMP WITH TIME ZONE

Syntax

CURRENT_TIMESTAMP [ (precision) ]

Arguments

precision specifies the fractional second precision of the returned time value. The default value is 6.

Examples

CURRENT_TIMESTAMP returns a value such as 08-AUG-06 11.18.31.082257 AM -08:00.

CURRENT_TIMESTAMP(2) returns a value such as 08-AUG-06 11.18.31.08 AM -08:00.