Siebel Global Deployment Guide > Deploying Siebel CRM 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 building PDQs. The functions Timestamp() and Today() return different results where time zones are concerned. 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.

  • 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.

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

Siebel Global Deployment Guide Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.