Find Jobs
Hire Freelancers

How to exclude weekends from DATE_SUB in mysql via function ASAP - open to bidding

$15-25 AUD / hour

Closed
Posted almost 9 years ago

$15-25 AUD / hour

Does anyone know how to exclude weekends from the DATE_SUB function in MYSQL? I am looking to search the past 1500 working days from CURDATE() but am struggling with the solution? I would like it in a function and it asap. Places like stackoverflow are too slow.
Project ID: 8007715

About the project

14 proposals
Remote project
Active 9 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
14 freelancers are bidding on average $19 AUD/hour for this job
User Avatar
Hello, I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. I have been working in the field of web development for roughly 7 years. I take great pride in my work and deliver only the best quality. My skill-set includes... -PHP -HTML5 -CSS -AJAX -Responsive Design -Joomla -Wordpress -Magento -Photoshop -Illustrator -Video Editing -Data entry I look forward to hearing from you and hopefully we will have the opportunity to work together. Thank you, Meagan S.
$21 AUD in 2 days
4.8 (156 reviews)
6.6
6.6
User Avatar
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
$20 AUD in 1 day
4.8 (55 reviews)
6.6
6.6
User Avatar
Aucune proposition n'a encore été fournie.
$15 AUD in 1 day
4.9 (137 reviews)
6.2
6.2
User Avatar
Hello Sir, I have been through your project description . I can design site with your requirement. Also I am very quick,affordable and reliable on my work. So let me know when we can start on. And yes if you need to look at my portfolio and reviews its on my profile. Best wishes from Rinkul :)
$20 AUD in 30 days
4.6 (43 reviews)
6.1
6.1
User Avatar
A proposal has not yet been provided
$21 AUD in 1 day
4.8 (43 reviews)
5.5
5.5
User Avatar
The following gives you an idea SELECT * FROM table WHERE WEEKDAY(date) > 0 and WEEKDAY(date) < 6 order by date limit 1500 you can use desc or asc depending on your requirement.
$15 AUD in 1 day
4.8 (22 reviews)
4.4
4.4
User Avatar
Hello Mate! I am interested in the project you posted. Their are lot of interested people here and they have lot of different things so i dont know you will reply me or not or even read my post or not but i want to let you know that we do have around 245 apps, 119 games and about 190 web based sites and softwares. I can even give you demo for it. I dont want to cheat you saying i did this and that but i want to say one word, if you will go with us you can definitely "TRUST" us. I WILL AGAIN SAY THAT I DONT KNOW THAT YOU ARE GOING TO READ ABOVE OR NOT BUT I WOULD ONLY SAY IF YOU CAN DISCUSS WITH US, YOUR PROJECT IS GOING TO BE DEFINiTE SUCCESS. Thanks Devang
$30 AUD in 3 days
5.0 (5 reviews)
3.6
3.6
User Avatar
A proposal has not yet been provided
$27 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can build a function/stored procedure in MySQL which would take two dates as its parameters and produce the days excluding the weekends. I'm available for any discussion on skype (Id: barkatmulani) or phone (0456 300 001). Experience: ----------------- I have been working with database designing, programming and data migration projects since last 8 years. Have done such projects on enterprise-level databases during my past job. Also having expert command on MS SQL database programming using stored-procedures. During my past employment with a health-care organization, I have been working on data migration project from the legacy database to PeopleSoft ERP on MS SQL. Have also been working on database development on a number of database servers including MySQL, MS SQL and Sybase.
$15 AUD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Alice Springs, Australia
5.0
1
Member since Mar 11, 2015

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.