Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise