increment by one month 2

[eHanSolo]

hi there,

I have managed to obtain the latest date in a list of dates by using the following:

SELECT date FROM mydata.data WHERE fund = "whatIwant" order by date desc limit 1


thing is, i actually want the latest date plus one month and then return this value. Any ideas?

Thanks.

 

[towerbase]

Try

SELECT DATE_ADD(date, INTERVAL 1 MONTH) FROM etc

Andrew
Hampshire, UK

 

[ericbrunson]

You may want to read this section of the manual:

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

paying attention to the "DATE_ADD" function.

 

[eHanSolo]

thanks guys. worked a treat!