I need a function for Postgres which works in Postres 8 and above which will take 2 timestamp parameters and give me the difference in business minutes.
There will be multiple other tables for holidays, working hours for each day etc but in the end, the function will return me one number for how many working seconds between 2 timestamps.
I have posted this before but the requirement has changed slightly to seconds and not hours.
9 freelancer bu iş için ortalamada 415$ teklif veriyor
Hi, I have years of experience with PL/pgSQL, and the function you're requiring sounds relatively straight forward, but would of course depend on the working hours / holidays tables that you've got planned.
Hello, I have 5 years experience with PortgreSQL and PL/SQL functions. Just need the specifics about how to get the non-working hours. Please, ontact me for further details, thanks.