1. 学ぶ
    2. /
  2. コース
    3. /
  3. Time Series Analysis in PostgreSQL
Connected

演習

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.

指示1 / 2

undefined XP
    1
    2

質問

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

選択肢