Exercise

Convert to a different time zone

Developers who work on customer facing applications used by people located around the world often need to convert date or time data into a format more accessible to their users.

In this scenario, you are a member of the data team for a news application. You are charged with the task of converting the timestamps given in the dc_news_dim table to the local time used in Paris, France. The timestamps given in the publishdate field do not have time zone information and are assumed to be provided in the UTC time zone.

Instructions 1/2

undefined XP

1
2

Question

What clause would you use to shift the time to a different time zone?

Possible Answers

AT TIMEZONE
CAST
::TIMESTAMPTZ
AT TIME ZONE
+ INTERVAL