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.
This exercise is part of the course
Time Series Analysis in PostgreSQL
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
