Simple Date Functions and Sliding Date Window Filters | Essential SQL

Learn how to use some simple date functions such as YEAR, MONTH, DAY, and GETDATE. Better yet, learn how use a sliding date window in your query – Translation write a query that returns dates less than two months from now. You can do this using GETDATE() and DATEDIFF. Learn how in this video. In this video I won’t go into too much detail and overwhelm you with every feature available to you for your use, but you’ll get some ideas on how to get information from a date, such as the difference between today and data to use within your query. This is a good thing, as being able to incorporate sliding date windows into your filter criteria makes your queries flexible and you a very cool person. Resources & Links ______________________________ Join the Course: https://www.essentialsql.com/EssentialSQLChallenge Online Tutorial: https://www.essentialsql.com/sql-tutorial/sql-joins-visual-explanation-and-introduction/ Query Results Using Boolean Logic: https://www.essentialsql.com/introduction-database-joins/