Store Time in MySQL + 5 HOURS - PHP

Hi - Does anyone know to store the CURRENT TIME + 5 HOURS in MySQL using a 'Time' Field....?

Many Thanks!!

 

First do the normal CURRENT TIME (an option in MYSQL) then in another line of code just add 5 hours.

 

There's a number of ways. Some examples:

$query = "UPDATE tableName SET timeField = NOW() + INTERVAL 5 HOUR";
$query = "UPDATE tableName SET timeField = '" . date("Y-m-d H:i:s", time()+(5*3600)) . "'";
$query = "UPDATE tableName SET timeField = '" . date("Y-m-d H:i:s", strtotime("+5 hours")) . "'";

PHP:

 

Many Thanks!!!

 

simple!

1. Define the type in database table. like (date or time)
2. Just use now() in the query.

 

phper's solution is good

 

phper's solution is correct.

 

Thanks guys! I originally had:

ADDTIME(CURTIME(), '5:00')

But that just added 5 as a number on - so if someone registered at 23:20 it would store as 28:20!! Thanks again