How to add time to the current time in MySQL

Question

how to add 3 hours to the current time in php ?

$expired = time() + "3 hours";
$time = time();

if($time < $expired){
    condition....
}

$time = time() + 10800; – Dipesh Shihora Jul 24 '15 at 05:58 — Dipesh Shihora, Jul 24 '15 at 05:58

score 1 · Answer 1 · edited Apr 23 '16 at 04:43

1

The DATE_ADD() function will work.

DATE_ADD(NOW(), INTERVAL 2 HOUR)

edited Apr 23 '16 at 04:43

kamal pal

answered Jul 24 '15 at 05:59

Santosh Jagtap

OP want to add 3 hour not 2 hour!!!! – Saty Jul 24 '15 at 06:00
2

Then add 3 instead of 2 in query. Above DATE_ADD is mysql function you can use it in query directly – Santosh Jagtap Jul 24 '15 at 06:01
Thanks sir. But i need to add the time in the code, not on the query – Harold Felix Jul 24 '15 at 06:09

1 Answers1