Siebel Global Deployment Guide > Deploying with Global Time Zone > About Global Time Zone and Universal Time Coordinated (UTC) >

About Time-Related Functions and UTC


This topic is part of About Global Time Zone and Universal Time Coordinated (UTC).

Users often need to know the current date or time when entering complex queries, or when building PDQs. The functions Timestamp() and Today() return different results where time zones are concerned.

  • Timestamp() returns the current date and time value adjusted for the time zone of the user.
  • Today() returns only the current date, and this is relative to the time zone of the database server.

Regardless of whether UTC is enabled, it is possible for the date returned by these functions to be different, depending on where the servers are located and on the user's local time zone offset.

For more information about these and other functions, see Siebel Developer's Reference.

Siebel Global Deployment Guide Copyright © 2007, Oracle. All rights reserved.