SQL Date-Time Cheatsheet

A short guide to steps, solution, and must-know terminology

Olga Berezovsky
Data Analysis Journal
2 min readJan 25, 2021

--

Working with timestamps and data formats in SQL can be tricky. Often dates are loaded and stored as strings, var, or else in databases. And yet, date-time values are the most common data manipulations in SQL. Below I’ll cover 3 important must-know date functions like DATEPART(), DATEADD(), DATEDIFF(), which often are asked…

--

--