Introduction
Dates
Time
Timestamps
Extract functions
Timezone conversion
27. AT TIME ZONE – additional practice
Intervals
Current date and time
Revision

Instruction

Alright! One more exercise with time zones and we're moving on.

Exercise

For each route with a distance greater than 600 km, show its code and its departure and arrival at the local time for Tokyo, Japan.

Stuck? Here's a hint!

Use AT TIME ZONE 'Asia/Tokyo'

Console

Code editor

Result

TableConsole