Mysql Date functions in php code

Hello friends,

The following query will add some times to mysql date column.

Get the today date :

$date = date(‘Y-m-d H:i:s’);

Convert it into strtotime and add which one we have to add, here i am going to add 30 minutes to existing time.

$newtime = strtotime($date . ‘ + 30 minutes’);

Covert the newtime to date format like below.

$newtime = date(‘Y-m-d H:i:s’, $newtime);

Here we will get the answer , same thing we can apply for mysql datetime column field also.

You may like these posts