PHP SQL to find customers who are on a six month renewal

Customers buy from us.

purchasedate: YYYY-MM-DD HH:MM:SS

renewaldate: YYYY-MM-DD HH:MM:SS

Ignoring the day and time.

I want to know which customers are renewing at the six month mark; i.e. purchasedate and renewaldate can be divided by six months.

So, this month, I need to know people who purchased in December 2018, June 2018, December 2017, June 2017, December 2016, June 2016, etc.

Next month I'd need to know people who purchased in January 2019, June 2018 January 2018, June 2017, January 2017, June 2016, January 2016, etc.


Skills: PHP, MySQL, SQL

See more: flash php sql highscore, create online reservation system php sql apache, basic php sql page, php sql site, dynamic link php sql database, web development languages html php sql, php script last month, mssql php sql injection, ikariam php sql, php sql sample code, php sql oscommerce, convert static web page dynamic php sql, create login connection php sql, code source sms gateway php sql, sent email php sql, php sql add text gama, php sql scripts vacation rental calendar, want images php sql, php ini file resolve problem customers log create account

About the Employer:
( 29 reviews ) Capalaba, Australia

Project ID: #20093443

Awarded to:


Hello, how are you? I am a creditist and php expert I am very happy to have an opportunity of bidding your project I have carefully read your posting and understood clearly what you want My rich php development experie More

$10 AUD in 1 day
(56 Reviews)

15 freelancers are bidding on average $26 for this job


Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. I have good skills in those. So I think I can help you if you want. Thank you. Best Regards.

$25 AUD in 1 day
(123 Reviews)

Hello Sir, I can write queries to display data in 6 month and 1month slot. I am willing to start right away. Please check my profile for work and experience. Regards Ashwin

$35 AUD in 1 day
(252 Reviews)

Hello! I can write a query to get result as per your need. I have very good experience in this. I would be really happy to hear from you. Thanks

$50 AUD in 1 day
(114 Reviews)

Hi, We can populate a listing where users can be shown whose renewal are on six month. Lets discuss this in detail so i can start the work today itself. Thanks Regards

$30 AUD in 7 days
(158 Reviews)

Hello ! I am a full stack developer for over 5 years on the ⭐⭐Especially sql query expert⭐⭐ I have read your description in more detail and have much interest in your project. I have many experiences More

$20 AUD in 1 day
(49 Reviews)

How do you do? I am a creditist. I'm very happy to have a chance of bidding your project. I have read carefully the descriptions and understood clearly what you want. I have experience in development of the projects li More

$20 AUD in 7 days
(29 Reviews)

Hi, I have read your job description carefully and i am very interested in this job. I am full stack web developer and i am very confident about this job. I will complete this job within a few hours. I can start worki More

$20 AUD in 1 day
(11 Reviews)

i can fix it fast please come to the chat...................................................................................................................................

$20 AUD in 1 day
(21 Reviews)

Hello, I am trusted HTML,CSS,JS,PHP, Wordpress & WooCommerce developer. I can provide it in given time and in less budget. I have been working on such type of projects for 2 years now .Please see the some links for re More

$20 AUD in 2 days
(20 Reviews)

Hello, After reading this job description, I am convinced that I would be a perfect fit for this role. That is because of - I am a PHP expert who has 12 years of experience with laravel, codeignitor, wordpress/MySQ More

$40 AUD in 7 days
(12 Reviews)
$30 AUD in 1 day
(1 Review)

Hi, I read you job description and I can do this job very professionally without loosing the quality of work. Please message me so we can discuss more details about the project. Thanks, Neil

$25 AUD in 1 day
(3 Reviews)
$25 AUD in 1 day
(0 Reviews)

Hi sir, I am interested to work with you. I am php, mysql expert. I also work on laravel. Please give me the opportunity to work with you.

$20 AUD in 2 days
(0 Reviews)