Take your SQL from Good to Great: Part 2

Written by The Count Team

Not always there when you call, but always on time.

This is part 2 of a 4-part series on some of my most valued SQL ‘hacks’. Check out the others in the series:

Part 1: Common Table Expressions

Part 2: All about those dates

Part 3: The other JOINs

Part 4: Window Functions

Part 5: User-Defined Functions

Dates & Times in SQL ⏰

No matter how long you’ve been writing SQL, dealing with dates and times is never a welcome task. They’re surprisingly thorny and can set you back hours when you’re least expecting it. So in this edition of the series, I’ll walk through some helpful date/time ‘hacks’ that should benefit novices and experts alike.