Skip to content

Instantly share code, notes, and snippets.

@dsmrt
Last active August 7, 2020 19:29
Show Gist options
  • Save dsmrt/312d4721fbd0124fda6024525037f402 to your computer and use it in GitHub Desktop.
Save dsmrt/312d4721fbd0124fda6024525037f402 to your computer and use it in GitHub Desktop.
SELECT justify_interval(
('2020-12-31'::TIMESTAMP - '2020-01-01'::TIMESTAMP)
)
-- results `1 year 5 days`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment