1 min read

How to convert php date into mysql format

Nikunj K0
1. MySQL column datatype is “DATE”

$date = date(‘Y-m-d’, strtotime(str_replace(‘-‘, ‘/’, $date)));

2. MySQL column datatype is “DATETIME”:

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

Share your Love
     

Leave a Reply

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

Website http://www.technologiespost.com/

Related Posts