It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Dates
Time
Timestamps
Extract functions
Timezone conversion
27. AT TIME ZONE – additional practice
Intervals
Current date and time
Review

Instruction

All right! 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. Name the last two columns local_departure and local_arrival.

Stuck? Here's a hint!

Use AT TIME ZONE 'Asia/Tokyo'