how to use date_add in mysql, please help

[owenewo]

i know to use it like this:
SELECT DATE_ADD('1998-01-01 00:00:00', INTERVAL '1 10' DAY_HOUR)

then, it will add 1 day and 10 hours to the datetime.
but if I have a table called time with two fields, days and hours, how can i usr it?

does it look like this?

SELECT DATE_ADD('1998-01-01 00:00:00', INTERVAL 'days hours' DAY_HOUR) newdate from time;

Please help.
Thank you in advance.

 

[r937]

try it in two steps, nested:

select date_add(
         date_add('1998-01-01 00:00:00'
                 , interval `days` day) 
               , interval `hours` hour) 
        as newdate 
  from `time`

rudy

http://r937.com/

SQL Consulting