MySQL Forums
Forum List  »  Newbie

Help on dates between logic
Posted by: Suresh Babu Kommuri
Date: August 15, 2017 04:04AM

Hello Experts,

I am new to MySql and looking for your help on getting below logic.

I wanted to create a view or table against my existing order table.
The new table columns are customer Name, Order ID, Order_date, Group

I wanted to load data for above fields from Order table by flagging to the group column.
0-1 month
2-3 month
4-6 month
7-12 month
> 1 year

the conditions for flagging group column are.
0-1 month Currentdate(15/08/2017) to 30days (15/07/2017)
2-3 month 15th July to 15th June
4-6 month 15th June to 15th Mar
7-12 mont 15th Mar to 15th Dec
Any order > 1 year

Regards,

Suresh

Options: ReplyQuote


Subject
Written By
Posted
Help on dates between logic
August 15, 2017 04:04AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.