Learn Standard SQL Functions | Interactive Course | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

27/46 AT TIME ZONE – additional practice

1. Introduction

3. Table aircraft

4. Table flight

5. Dates in SQL

6. Date format explained

7. Dates with logical operators

8. Dates with BETWEEN

9. Dates with ORDER BY

10. Dates – additional practice

11. Time in SQL

12. Time with logical operators

13. Time with BETWEEN

14. Time with ORDER BY

15. TIME – additional practice

17. Timestamps explained

18. Timestamps with constant values

19. Timestamps with BETWEEN

20. Timestamps with ORDER BY

21. Timestamps – additional practice

22. EXTRACT(field FROM column)

23. EXTRACT – example

24. EXTRACT with a wrong data type

25. EXTRACT with a wrong data type – continued

26. AT TIME ZONE

27. AT TIME ZONE – additional practice

28. Difference between timestamps

29. INTERVAL YEAR TO MONTH

30. INTERVAL DAY TO SECOND

31. INTERVAL 'x' FIELD

32. INTERVAL with constant values

33. INTERVAL with constant values – continued

34. INTERVALs with comparison operators

35. INTERVALs with comparison operators – additional practice

36. Current_date, current_time and current_timestamp

37. Current date & time with intervals

38. Current date & time with intervals – additional practice

46. Congratulations

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

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.

Use AT TIME ZONE 'Asia/Tokyo'

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.