Nice work! Another thing we want to introduce is the conversion between various time zones. As you know, the
route table provides the departure and arrival times in Central European Time. Let's see how we can show the same time in different timezones:
launched_timestamp AS original,
launched_timestamp AT TIME ZONE 'Asia/Tokyo' AS tokyo
As you can see, we need to write
AT TIME ZONE followed by the timezone in apostrophes. In our database, we usually provide the time zone in the format
Continent/City, but you need to watch out, because PostgreSQL has other conventions.