How to add 7 days to mysql date?

[eluser]AgentPhoenix[/eluser]
Interesting. I didn't know MySQL had those. Do other database types (Oracle, MS SQL, SQLite, PostgreSQL) have those as well?

Personally, I've started doing everything with UNIX timestamps lately. It makes it pretty easy to store and display times, plus, when you want to add say 7 days, you can just do the math (number*86400) to find out the UNIX timestamp in the future.