MySQL - reference column in function call

Question

I got a number in a table, which I want to use for the DATE_ADD function in MySQL.

So something like this:

SELECT DATE_ADD('2011-01-02', '+INTERVAL some_table.column DAY') AS newdate FROM some_table

This will however not work, as MySQL will not understand some_table.column is a column with a value etc. Any help please?

eumiro · Accepted Answer · 2011-01-27 14:31:06Z

2

Don't use quotes:

SELECT DATE_ADD('2011-01-02', INTERVAL some_table.column) AS newdate FROM some_table

answered Jan 27, 2011 at 14:31

eumiro

214k36 gold badges307 silver badges264 bronze badges

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

2 Comments

I'm trying to do this more specifically: SELECT DATE_ADD('2011-01-02', +INTERVAL column DAY) AS newdate FROM table. It gives me SQL error.

There shouldn't be a '+' in that statement.