Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Peter Redding
February 9, 2007, 4:28 pm
rate this thread
I have a query that uses a user variable to get the latest date from a
table using the MAX function. I then need to add 1 month onto this
date using DATE_ADD but the query just returns a NULL for the second
Here's my query:
#This displays correctly
#This just returns (NULL)
DATE_ADD(@lastchecked,INTERVAL 1 MONTH ) as lastcheckedplus1month
Has anyone managed to use DATE_ADD with a user variable? Can you tell
me if I'm missing something?
Any help is greatly appreciated.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum