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.

Anil Kumar Panigrahi

With more than 10 years experience in PHP and Founder of Anil Labs, a blog for PHP and related posts. contributed posts regarding CodeIgniter, CakePHP and Learn PHP online ... Contact : [email protected]

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.