Updating fields and changing NOW()

[iceraider]

ok say I update a row by

set expiration=NOW()

How do I make it set it to the current date plus 1 extra month?

[LordShryku]

Is this a timestamp field or a date field?

Either way, I'd calculate it outside of the query with PHP

[iceraider]

Actually it's date field

Got any suggestions.

Like code samples of how to add 1 month or 2 months or 3 months to something.

[iceraider]

I need to grab current date add 1 or more months too it, then upload it in date format(YYYY-MM-DD)

[LordShryku]

$monthAway = date("Y-m-d", strtotime("+1 month"));
$sql = "UPDATE table
        SET expiration = '".$monthAway."'";

[iceraider]

Thanks LordShryku !

[LordShryku]

yarr 😉

[Drakla]

You can also get MySQL do do it for you with guffage like:

SELECT NOW() + INTERVAL 1 MONTH;

it's also good for doing comparisons in where

SELECT whatever FROM somewhere WHERE dateField > (NOW()+INTERVAL 14 DAY);

If you've got an index on the dateField then don't do any calculations on that value, do it the other side of your comparitor otherwise the index won't be used.