Description
Changes a datetime value’s time zone from the value’s original time zone to the time zone given in tz_string and returns the value.Syntax
SwitchTimeZone(datetime_expression, tz_value)
Arguments
datetime_expression - datetime expression in original time zone. tz_value - string representing the target timezone. See http://joda-time.sourceforge.net/timezones.html for available time zone values.Examples
SwitchTimeZone(ToDate('2014-11-01T23:30:00+02:00'),'America/Chicago') returns 2014-11-01T15:30:00-06:00