Home Product Data Sources Customers Company Jobs Resources SQL School Playbook Sign In

PostgreSQL Date Functions (and 7 Ways to Use Them in Business Analysis)

Timestamps are crucial to business analysis for a very simple reason: they tell you when things happen. Imagine trying to suss out trends in your data, like monthly web traffic, or quarterly earnings, or daily order volume without knowing when events occurred. It’d be a nightmare.

PostgreSQL offers a variety of date functions for manipulating timestamps. To separate the useful from the obscure, we’re sharing how-tos for the most frequently used Postgres date functions and business scenarios where they come in handy.

Read More >