Find Jobs
Hire Freelancers

Write some Software

$10-30 USD

Completed
Posted about 8 years ago

$10-30 USD

Paid on delivery
We require a Java application or a stored procedure Oracle (PL / SQL) that contains a function that receives to parameters: 1. Start date and time 2. End date and time Given these two dates, the application should query a parametric table in a database, which contanis days and business hours and another table which contains public holidays (these tables already exist and they will be given to you to query on them). With this information, the function should calculate the business duration between these two dates, ie: good time interval. Example: Start Date: "01/04/2016 13:00:00" end date "02/04/2015 13:00:05" Day 01 from month 04 is Sunday, and this day is not a business day according to the calendar of the given table. Thus, the calculated duration starts from day 02 from Month 04. As parameterised working hours is 8 a.m. to 12 p.m., the total duration is: Duration: "00 00 4:00:00" The function must also subtract holidays, which are parameterised in other table. Regards,
Project ID: 10422447

About the project

18 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi I have 15+ years of experience in developing applications on oracle database. I have bachelor degree in cs, 25 oracle certified trainings and web app dev certificate from University in Chicago. For your request I will develop plsql function. Curently I support some plsql packages for telecom company so I have experience in similar taskt. please share details about tables for this request. I will be glad to work for you on this project. Regards
$35 USD in 1 day
4.8 (27 reviews)
4.7
4.7
User Avatar
I can write this as a PL/SQL function. My bid is serious, I have more than 6 years experience with Oracle, working 8 hours a day on Oracle. I am not just a "hobby oracle developer". It can probably also be done as an expression you can use in a query without having to use the function, making the whole query much faster for larger data volumes.
$30 USD in 1 day
5.0 (4 reviews)
3.8
3.8
18 freelancers are bidding on average $30 USD for this job
User Avatar
Plz send me tables. I have 10+ years experience and more than 600 projects completed on this platform. Please send me complete details. I am very interested to work on this project. Ready to start ASAP.
$50 USD in 1 day
4.8 (507 reviews)
7.5
7.5
User Avatar
I have a good grip on java and web services. Since i am new to this website so i bid low . Award me the project and i guarantee that you won't regret your decision.
$25 USD in 1 day
5.0 (68 reviews)
5.8
5.8
User Avatar
hey I have good experience in java and mysql. I also have some certifications in it. I can share some of my demos with you if you want for better understanding. And most importantly, you will get your project done before the deadline.
$10 USD in 1 day
4.9 (42 reviews)
5.1
5.1
User Avatar
Hello, I am interested in your project. I am a software engineer and I have profissional experience with SQL. I suggest to do this procedure in PL SQL. Thank you, Best regards, David
$20 USD in 3 days
5.0 (17 reviews)
4.0
4.0
User Avatar
I have 10+ years experience in Java / j2ee using Linux and Windows. I can do this work. Could you please assign it to me? Thanks
$30 USD in 2 days
5.0 (4 reviews)
3.9
3.9
User Avatar
Need a JAVA-SQL application? Not an issue, I have hands on experience in developing such apps as you can see at my profile. If you want i can show you some sample of my work. I have a great grasp on quereing through Java to SQL db and fetch the required results. Looking to hear from you. Thanks
$55 USD in 1 day
4.8 (8 reviews)
3.8
3.8
User Avatar
Greetings, This task would get done during a hour or 2 Both Java driven and PL/SQL driven approaches would be used here. Please contact me if you are interested. Thank you.
$55 USD in 1 day
3.5 (17 reviews)
3.9
3.9
User Avatar
I am not going to waste your time by writing here a copy pasted proposal. I have completely read your project description and i can develop JAVA APPLICATON THAT QUERY TABLE TO GET THE REQUIRED INFORMATIO BY PUTTING 2 ARGUMENTS AS INPUT. If you want to see some samples of my work related to this project please send me a message for my general portfolio please have a look at my profile and feedback on my profile. I am looking forward to work with you. Thanks!
$25 USD in 1 day
5.0 (5 reviews)
2.5
2.5
User Avatar
Hello, I have 3 years of experience in Java EE & spring development, I worked for many projects of big companies. I master Sping (Spring IOC, Spring MVC, Spring SECURITY, Spring BATCH),webServices, Oracle (SQL,PL/SQL) and lot of other technologies, I'am available for other information
$40 USD in 1 day
5.0 (1 review)
1.4
1.4
User Avatar
Sir,as a java coder i understood your problem and i will compelete it with less line of codes and the program will work efficiently .
$25 USD in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
Talk of Java, think of Peter. I am a student, and programmer, why not choose me for your project? Thank you in advance.
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a lot of experience in SQL working with a complicated databases with over 300 tables and complex relations between them.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm not focusing on project cast I believe in long term works together. I need starter for my freelance carrier. I'll accept this project as you pleased to give me but with 5/5 feedback. For the last three years I have been working in the similar role to the one you are advertising, and have been responsible for designing, building, testing and supporting Java Web Applications. I have extensive experience of Java (Core), Java Web Development, JSF, Spring Framework, Hibernate, JSP/Servlets, HTML, XHTML, JavaScript, AJAX, CSS, Java Web Services, SQL, Logging, Data Bases(Oracle & MySQL) , IDE (Eclipse & NetBeans), Load/Stress Testing (JMeter) and Application Servers (Apache Tomcat & JBoss/WidlFly). I consider myself an export at resolving application defects, and at testing, debugging, and refining software to produce the required product. I have complete understanding of SDLC. On a personal level I have the ability to stay organized and on top of my work at all times. I love to learn new technologies to improve my skills and up to date myself with latest development in the world of Java.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I work with Java projects for over 10 years and I'm sure that I have the necessary requirements for your project. I intend to solve the problem posed with a Java executable class (Java Application) who will have a method responsible for receiving the two dates and return the desired duration. The class will also have other private methods to support the solution, for example, to fetch the data in the database. Requirements for the start of the project: - Detailed structure of related tables - Sample records of each of the related tables. I am available for clarification that may be necessary. Thanks in advance! Rosi
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of COLOMBIA
Bogota, Colombia
4.9
5
Member since Oct 29, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.