Learn Standard SQL Functions | Interactive Course

38/46 Current date & time with intervals – additional practice

1. Introduction

2. Table route

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

16. Timestamps

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

All right! Let's do one more exercise on this topic.

Find the code of all the routes which normally depart within 3 hours from the current time.

The interval you're looking for is:

BETWEEN CURRENT_TIME AND CURRENT_TIME + INTERVAL '3' HOUR

Instruction

Exercise

Stuck? Here's a hint!

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Standard SQL Functions

Instruction

Exercise

Stuck? Here's a hint!

Need assistance?