SQL From Zero to Hero in 30 Days — Day 8 Date Manipulation
4 min readDec 9, 2021
Learn, practice, master.
The links below will be updated as we progress into the series:
- Day 1: Introduction
- Day 2: The Select
- Day 3: Filtering
- Day 4: The Group by
- Day 5: Expanding the Group by
- Day 6: Working With Text
- Day 7: Working With Text 2
- Day 8: Date Manipulation
Welcome to day 8 of this series!
As we move forward, the topics become more specific focusing on a particular set of operations. In this part, we will be covering different ways of manipulating dates with SQL.
Note: Although the SQL syntax is mostly the same in different RDBMSs, there are some minor differences. Thus, it is important to emphasize that we will be using Microsoft SQL Server as RDBMS in this series.
I prepared a sales table filled with mock data that we can use for the examples. Let’s first take a look at this table.
