Skip to content

Instantly share code, notes, and snippets.

@calexandrepcjr

calexandrepcjr/only_weekends_psql.sql

Created April 1, 2021 20:41
Show Gist options
  • Save calexandrepcjr/16fcb0c73a17d0fadf26f188c33dad13 to your computer and use it in GitHub Desktop.
Save calexandrepcjr/16fcb0c73a17d0fadf26f188c33dad13 to your computer and use it in GitHub Desktop.
Download ZIP
Extract only rows from weekends
Raw
only_weekends_psql.sql
SELECT
*
FROM table
WHERE EXTRACT(ISODOW FROM created_at) IN (6, 7);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment