Kapalı

Difference in business minutes SQL procedure

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.

Beceriler: PostgreSQL

Daha fazlasını görün: business minutes, minutes business, how a business works, business works, sql business, business requirement, postgres difference business hours, business hours function, postgres business hours, function postgres, postgresql procedure, postgresql sql, postgres business hours function, sql postgres, sql multiple tables, business function, postgresql function procedure, function procedure postgresql, sql day, postres, return true false stored procedure sql, postgres timestamp, sql procedure return, difference, sql procedure

İşveren Hakkında:
( 8 değerlendirme ) Morzine, South Africa

Proje NO: #4419581

9 freelancer bu iş için ortalamada 415$ teklif veriyor

getveltrod

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te Daha fazlası

in 25 gün içinde721$ USD
(0 Değerlendirme)
0.0
zkutch

Hello. More 20 years programming experiense.

in 7 gün içinde500$ USD
(0 Değerlendirme)
0.0
manask1703

Hi My Name is Krishna and I am a Sr. ETL Developer located in India. I would love to have the opportunity to interview with you about your posting. Details of my skills and experience as well as sample of work ca Daha fazlası

in 7 gün içinde440$ USD
(0 Değerlendirme)
0.0
damirmarkovic

I have years of experience with PL/pgSQL, so I can help you with your project. It would be great if you could provide me sample of your database, with those holidays and working hours tables. If you have any question Daha fazlası

in 5 gün içinde357$ USD
(0 Değerlendirme)
0.0
IgnacioB

Hello Helen. I would like to do this project. My name is Ignacio and I'm a Postgres Specialist. As a Postgres DBA I have to manage postgres version 8,x and 9.x, So I can write the stored proc or function you need for p Daha fazlası

in 7 gün içinde250$ USD
(0 Değerlendirme)
0.0
vlchung

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.

in 4 gün içinde286$ USD
(0 Değerlendirme)
0.0
srrajeev

I have done plenty of projects of various scales on PosgreSQL and have expertise in writing such functions using Postgres 8.x to 9.1. Function code will be cleaning written with clear comments. Performance of the funct Daha fazlası

in 3 gün içinde350$ USD
(0 Değerlendirme)
0.0
sswijaya

Hi, I will help you with this project. Thanks.

in 5 gün içinde330$ USD
(0 Değerlendirme)
0.0
nicamlg

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.

in 3 gün içinde500$ USD
(0 Değerlendirme)
0.0