A Visual Summary of SQL Date/Time Functions

Preparing for SQL interviews?

Between timestamp, date, and time data types, SQL date/time functions can be quite confusing. In this blog, I will attempt to map out the common data/time commands in SQL interviews using PostgreSQL syntax.

Before SQL Code

Before we start to code, let’s first pause and think about the elements in date/time representations. We know that time is linear, goes one way, and can be represented mathematically as a vector. …

data science data-science-interview datetime postgresql sql summary time