Learn Common Functions in MS SQL Server By Doing | Interactive Course | Vertabelo Academy

Best April deals - hours only!Up to 80% off on all courses and bundles.-Close

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.