Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Timestamp

The Timestamp function in Expression Builder returns the server date and time converted to the current user's time zone setting. For example, if the current user's time zone setting is set to Eastern Daylight Time (EDT) -0400 UTC, the Timestamp function converts the server time to EDT. The TimeStamp function performs UTC (universal time code) conversion.

NOTE: Arithmetic operations (for example, add or subtract) are not supported with the Timestamp() function.

Syntax

Timestamp()

Result Type

Date Time

Examples

The following example returns the current date and time, in the format month/day/year hours24:minutes:seconds:

Timestamp()

Related Topics

See the following topics for related Expression Builder information:


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.