Converts a date from the given time zone to a specified time zone.
totimezone ( datevalue, fromzone, tozone )
| datevalue |
A date or bigdatetime. |
| fromzone |
A string representing a legal time zone. |
| tozone |
A string representing a legal time zone. |
Converts a date from a given time zone to a new time zone. The first argument is the date being converted, the second argument is the original time zone, and the third argument is the new time zone. Time zone values are taken from the industry-standard TZ database. The first argument must be a date; the second and third arguments must be strings that represent legal time zones. The function returns a date.
totimezone(v.TradeTime, 'GMT', 'EDT') converts the time portion of each TradeTime from Greenwich Mean Time to Eastern Daylight Time.