newbie now() question

[shawjames]

hello,
I cannot seem to find out how to do this...

I know if I use now() in my sql code, it will set the date to today.

how do I set the date 2 days ahead?

To give the value:

"2005-04-08"

for example?

[eoghain]

Depends on your database, but most of them have a function called date_add() or some such that you can use like this:

update myTable set myDate = date_add(now(), interval 2 days);

Or some such, you should look up the proper syntax in your database documentation.

[Sxooter]

Starting with one of the later versions, MYSQL started supporting standad intervals, as defined by the SQL spec. PostgreSQL, oracle, and most other dbs support them as well, so you'd just do:

select now() + interval '2 days';