Learn How to Use T-SQL Date and Time Queries by Doing - T- SQL Online Course | Vertabelo Academy

Vertabelo Academy

- Log in
- Create free account

Back to course details

To access to this exercise you need to buy
Common Functions in MS SQL Server course.

Learn how to use common T-SQL functions to process various types of data with ease. Soon, you’ll be able to modify textual data, perform calculations, round numbers up or down, change date and time formats, and even adjust time zone info!

What you get?

149 interactive exercises
Lifetime access
Certificate of completion
30 days money back guarantee

Buy the courseSee course details

10/54 Practice time!

1. Introduction

2. The Route table

3. The Aircraft table

4. The Flight table

5. Dates in T-SQL

6. DATE: The T-SQL default format

7. Using logical operators with dates

8. Using BETWEEN with dates

9. Sorting dates with ORDER BY

10. Practice time!

11. Time in T-SQL

12. Using logical operators with time

13. Using BETWEEN with time

14. Sorting by TIME columns

15. Practice time!

16. Date and time

17. Date and time data types

18. Using date and time with constant values

19. Using BETWEEN with date and time data

20. Sorting date and time data with ORDER BY

21. Practice time!

22. The YEAR(), MONTH(), and DAY() functions

23. Using YEAR(), MONTH(), and DAY() with aggregate functions

24. Using the DATEPART() function

25. Using the DATEPART() function in grouping

26. The DATENAME() function

27. Practice time!

28. The DATEADD() function

29. The DATEADD() to subtract dates

30. The DATEDIFF() function

31. The EOMONTH() function

32. Practice time!

33. The CAST() function

34. The CONVERT() function

35. The AT TIME ZONE function

36. The FORMAT() function

37. Practice time!

38. Getting the current date and time in T-SQL

39. The CURRENT_TIMESTAMP and GETDATE() functions

40. The GETUTCDATE() function

41. High-precision date and time functions

42. Current date and time

43. Current date and time in queries

44. Current date and time in queries—additional practice

45. What we've learned so far

46. The DATEFROMPARTS() function

47. Other functions

54. Congratulations

Okay, let's try a more complicated example!

For each aircraft produced in 2010, show its ID, its production date, and the codes for the routes it flies.

To show the codes, you will need to JOIN two tables. Use DISTINCT to get each unique route code.

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.