Skip to content

Instantly share code, notes, and snippets.

@eyanq

eyanq/postgres_util.sql

Created April 11, 2017 08:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save eyanq/2c1df419dbb84ab1526ad998e3bb9d9c to your computer and use it in GitHub Desktop.
Save eyanq/2c1df419dbb84ab1526ad998e3bb9d9c to your computer and use it in GitHub Desktop.
Download ZIP
Useful PostgreSQL Queries
Raw
postgres_util.sql
-- get last week first day and last week last day
SELECT
(to_date(concat(EXTRACT(YEAR FROM CURRENT_DATE),EXTRACT(week FROM CURRENT_DATE - '1 week' :: INTERVAL)),'iyyyiw'))::text AS start_date,
(to_date(concat(EXTRACT(YEAR FROM CURRENT_DATE),EXTRACT(week FROM CURRENT_DATE - '1 week' :: INTERVAL)),'iyyyiw') + 6)::text AS end_date
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment