将MIkrotik日期时间转换为Mysql日期时间[关闭]

Question

i have array where one of the key is datetime , and its value format looks like this :

dec/10/2017 01:50:33

and my problem is , when i insert to database , the value changes become like :

0000-00-00 00:00:00

Could you help me to fix that ?? how to fix that in php, Thanks

Answer 1

Use str_replace and date and strtotime method

Easy and Simple like this:

   $date = 'dec/10/2017 01:50:33';
   $formatedDate = str_replace('/', '-', $date);
   echo date('Y-m-d H:i:s',strtotime($formatedDate));

Output:

  2017-12-10 01:50:33