Mysql DATE_ADD INTERVAL with mysql table fields

Question

I have one table called datas in there I have id,start_date,end_date,day_count,day_type.
Where id is primary key,start and end_date is datetime, day_count is int and day_type is varchar. Now day_type store DAY,WEEK,MONTH as value when user made request and day field hold number of days like 1 to 60.

Now I want to user this count and type in date_add mysql built-in function.

I have tried to pass it as below but its show error.

SELECT
datas.day_count,
datas.day_type,
MIN( datas.start_date ) AS MinDate,
MAX( datas.end_date ) AS MaxDate, 
DATE_ADD(MaxDate,INTERVAL datas.day_count datas.day_type) AS ExactDate,
datas.trade_service_id
FROM datas

Erro is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'datas.day_type)) AS ExactDate, datas' at line 13 Please little hint would be great.

Please edit the question and add the error you are getting.

walrii
– walrii

2012-08-22 07:10:01 +00:00
Commented Aug 22, 2012 at 7:10 — walrii
– walrii, Commented Aug 22, 2012 at 7:10
Same as stackoverflow.com/questions/888971/…

Barmar
– Barmar

2012-08-22 07:11:20 +00:00
Commented Aug 22, 2012 at 7:11 — Barmar
– Barmar, Commented Aug 22, 2012 at 7:11

valex · Accepted Answer · 2012-08-22 07:51:00Z

15

This query works in MySQL but what do you exactly want to output without Group and so on?

SELECT
datas.day_count,
datas.day_type,
MIN( datas.start_date ) AS MinDate,
MAX( datas.end_date ) AS MaxDate,

start_date, min(start_date) as min_date,
case day_type 
  when 'MONTH' then DATE_ADD(MAX( datas.end_date ),INTERVAL datas.day_count MONTH) 
  when 'DAY' then DATE_ADD(MAX( datas.end_date ),INTERVAL datas.day_count DAY) 
end as ExactDate,

datas.trade_service_id
FROM datas

answered Aug 22, 2012 at 7:51

valex

24.2k7 gold badges47 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

DaveK Over a year ago

exactly what I needed to know, that I can't use a field as the interval type. CASE works fine as an alternative.

Collectives™ on Stack Overflow

Mysql DATE_ADD INTERVAL with mysql table fields

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related