Dealing with Timezones

Problem

A user in Tokyo ordered an item on Tuesday, but the database stored it as Monday because the server is in California. The analytics dashboard is completely incorrect for global sales. Write a query that outputs concept with the value: "Store timestamps in UTC and convert to local timezones on read using AT TIME ZONE."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution