Print      Open PDF Version of Online Help


Previous Topic

Next Topic

UtcConvert Function

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.

Argument

Description

utc_date_time

The date and time according to the current user's time zone setting in the format: MM/DD/YYYY HH24:MI:SS

time_zone

The name of a time zone

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

Related Information

See the following topics for related Expression Builder information:


Published May 2008