Skip to content

Instantly share code, notes, and snippets.

@msammarco

msammarco/gist:4d3ec6b60459c7cdc2b57458194340f4

Created July 28, 2016 16:19
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 msammarco/4d3ec6b60459c7cdc2b57458194340f4 to your computer and use it in GitHub Desktop.
Save msammarco/4d3ec6b60459c7cdc2b57458194340f4 to your computer and use it in GitHub Desktop.
Download ZIP
Postgresql - DATEDIFF UDF
Raw
gistfile1.txt
-- Does just diffing between dates
CREATE OR REPLACE FUNCTION DATEDIFF(units VARCHAR(30), date, date)
RETURNS int
LANGUAGE sql
AS
$$
SELECT abs(($2 - $3)::INTEGER) as DateDifference
$$;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment