Using the Timestamp Function

The Timestamp function returns the date and time for today. For example:

01/02/2012 11:15:22

You can use this function in a query. For example:

Created >= Timestamp() - 0.1

This code returns records that Siebel CRM created in the last one-tenth of a day.

Any expression that uses the TimeStamp function uses the date and time from the user computer even if the Siebel Server computer uses a different time zone.

The Today function and the Timestamp function might return different results. The TimeStamp function does UTC (universal time code) conversion. The Today function does not do UTC conversion.