Closed

Business hours function in Postgres

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 hours.

There will be multiple other tables for holidays, working hours for each day etc but in the end, the function will return me two numbers for hours and minutes which are the working hours and minutes between 2 timestamps.

Skills: SQL

See more: postgres difference business hours, business hours function, postgres business hours, numbers function, function numbers, postgres business hours function, business works, two hours, sql business, postgres, business hours, minutes business, business minutes, function postgres, sql postgres, sql multiple tables, business function, numbers business, works hours, postres, postgres timestamp, javascript calc business day, difference hours, postgres function tipo procedure, return tables sql

About the Employer:
( 8 reviews ) Morzine, South Africa

Project ID: #4347177

7 freelancers are bidding on average $129 for this job

InSolWorld

Hi, I have experienced in similar projects. I strongly believe that I will complete your project well and delivery your expected result. Best Regards.

$30 USD in 2 days
(2 Reviews)
1.7
mageny

I work with SQL and PL/SQL since 1992, including ETL and Data Warehouse and I have Oracle Certified Professional (Internet Application Developer Rel. 6/6i). I was instructor of Oracle Academy in Brasil, including those More

$150 USD in 3 days
(1 Review)
1.6
PROBLEMISH

I have studied your project requirement I can do this project easily I have done this type of work many time. I have done allot of work in Custom PHP and other please check out my links. Links of related projects .. More

$120 USD in 3 days
(0 Reviews)
0.0
oplalchandani

Hi I am an expert in Postgre and SQL Confident about this work

$200 USD in 3 days
(0 Reviews)
0.0
kjkhalasi

I have been working as a senior Software developer for 7 years, I have done lot of work in SQL like create complex stored procedures, functions, triggers etc.

$125 USD in 3 days
(0 Reviews)
0.0
spelko

I have Ph.D. in computer science.

$250 USD in 3 days
(0 Reviews)
0.0
viji999

I have more than 6 years of experience in SQL. Would definitely like to help you with this requirement. As the no. of tables is not mentioned in the Project Description, I'm opting for a relaxed timeline. If the amount More

$99 USD in 5 days
(0 Reviews)
0.0
ilianMad

Hi, I don't have experience with PostgreSQL, but i do have a lot with Transact SQL and I'm curtain I can do the function for you.

$30 USD in 3 days
(0 Reviews)
0.0