Skip to content

Instantly share code, notes, and snippets.

@Mattia98

Mattia98/get time before strike.sql

Last active January 23, 2017 08:08
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 Mattia98/6bb1bce8965d818aff2dce9f896477fb to your computer and use it in GitHub Desktop.
Save Mattia98/6bb1bce8965d818aff2dce9f896477fb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get time before strike.sql
SELECT extract(epoch FROM age(min("startDate")))/86400 FROM strikes WHERE "companyId" = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment