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.
The following example returns the current date and time, in the format month/day/year hours24:minutes:seconds:
See the following topics for related Expression Builder information:
|Published 5/4/2012||Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.|