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

LOCALTIMESTAMP

LOCALTIMESTAMP returns the current date and time in the session time zone.

Return Value

TIMESTAMP

Syntax

LOCALTIMESTAMP [ (timestamp_precision) ]

Arguments

timestamp_precision specifies the fractional second precision of the time value returned.

Examples

LOCALTIMESTAMP returns a value such as 09-AUG-06 08.11.37.045186 AM.

LOCALTIMESTAMP(2) returns a value such as 09-AUG-06 08.11.37.040000 AM.