Skip to content

Instantly share code, notes, and snippets.

@23maverick23

23maverick23/project_task_duration.sql

Created May 1, 2014 15: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 23maverick23/9f6063e953b0e4afb7b9 to your computer and use it in GitHub Desktop.
Save 23maverick23/9f6063e953b0e4afb7b9 to your computer and use it in GitHub Desktop.
Download ZIP
NS: Project task duration
Raw
project_task_duration.sql
(TO_CHAR({enddate},'J') - TO_CHAR({startdate},'J'))+1 - ((((TRUNC({enddate},'D'))-(TRUNC({startdate},'D')))/7)*2) - (CASE WHEN TO_CHAR({startdate},'DY','nls_date_language=english')='SUN' THEN 1 ELSE 0 END) - (CASE WHEN TO_CHAR({enddate},'DY','nls_date_language=english')='SAT' THEN 1 ELSE 0 END)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment