Calculate Working Days between dates
Posted on 2010-11-12
I am working on a Postgres DB that gets populated with data from Excel files.
In this DB I have a table with some columns with a type of timestamp without time zone
like: Creation_Date_UTC and Closure_date_UTC
What I want is maybe a function able to calculate "Working Days" (Bussines days <Monday to Friday>) from the interval in those two columns (or others I specify in the query).
ie: get_working_days(Creation_Date_UTC, Closure_date_UTC)
My date format in postgres is DD/MM/YYYY.
Thanks so much!