mysql NOW() + $seconds php?

Question

Is it possible to use mysqls NOW() function and add seconds to or from it?

Like so;

$q = $dbc -> prepare ("UPDATE account SET time = NOW() + $seconds WHERE id = ?");

Thanks

Answer 1

If you want to do this in MySql, you can either use

DATE_ADD(NOW(), INTERVAL $seconds SECOND)

or

UNIX_TIMESTAMP() + $seconds

Source

• unix_timestamp()
• date_add()
• INTERVAL $seconds

Answer 2

You can add seconds to it with DATE_ADD():

$q = $dbc -> prepare ("UPDATE account SET time = DATE_ADD(NOW(), INTERVAL $seconds SECONDS) WHERE id = ?");