Print      Open PDF Version of Online Help

Administering Oracle CRM On Demand > Expression Builder > Expression Builder Functions > UtcConvert

UtcConvert

The UtcConvert function in Expression Builder converts the specified date and time from the current user's time zone setting, and returns the date and time in the specified time zone.

Syntax

UtcConvert(utc_date_time, time_zone)

Result Type

Time

Arguments

The following table describes the arguments for the function.

Examples

If the current user's time zone setting is (GMT-05:00) Eastern Time (US & Canada), the following example:

UtcConvert('12/14/2007 17:07:05', 'Pacific Standard Time')

returns the following value:

12/14/2007 12:07:05

If the current user's time zone setting is (GMT+05:30) Calcutta, Chennai, Mumbai, New Delhi, the following example:

UtcConvert('12/14/2007 15:07:05', 'Eastern Standard Time')

returns the following value:

12/14/2007 04:37:05

The following examples show how to get the corresponding UTC time for Western European Time:

UtcConvert(Timestamp(),"(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna")

UtcConvert(Timestamp(),"W. Europe Daylight Time")

UtcConvert(Timestamp(),"W. Europe Standard Time")

The following examples show how to get the corresponding UTC time for South African Time:

UtcConvert(Timestamp(),"(GMT+02:00) Harare, Pretoria")

UtcConvert(Timestamp(),"South Africa Daylight Time")

UtcConvert(Timestamp(),"South Africa Standard Time")

If the name of a time zone contains a special character, such as a single quotation mark (') or a comma (,), you must enclose the name of the time zone, or the special character, in double quotation marks. For example:

%%%UtcConvert('08/03/2009 12:01:33',"(GMT+13:00) Nuku" + "'" + "alofa")%%%

%%%UtcConvert('08/03/2009 12:01:33', "(GMT+13:00) Nuku'alofa")%%%

Related Topics

See the following topics for related Expression Builder information:

• About Expression Builder
• Using Expression Builder
• Expression Builder Functions