convert Y/M/d H:i to db format in php

Question

I have code:

$date= "2016/Apr/16";
$time="5:00 PM";

I want to convert it to DB format like 2016-04-16 17:00:00 in php . I am not getting exact code from anywhere.

http://php.net/strtotime http://php.net/date or rather http://php.net/DateTime — Charlotte Dunois, Apr 16 '16 at 11:12
What you have tried so far? Post your attempts. Looking at your rep it seems you're not new to SO — Narendrasingh Sisodia, Apr 16 '16 at 11:18
`echo DateTime::createFromFormat('Y/M/dg:i A', $date.$time)->format('Y-m-d H:i:s');` — Mark Baker, Apr 16 '16 at 11:35

score 1 · Accepted Answer · edited May 23 '17 at 12:31

1

This way will solve your problem.

<?php
$date= "2016/Apr/16";
$time="5:00 PM";
$fullDate = str_replace('/','-',$date) . " " . $time;
$newDate = date("Y-m-d H:i:s", strtotime($fullDate));
echo $newDate;
?>

Result

More Examples;

http://www.w3schools.com/php/func_date_strtotime.asp

Convert date format yyyy-mm-dd => dd-mm-yyyy

edited May 23 '17 at 12:31

Community

1
1

answered Apr 16 '16 at 11:27

B.Kocaman

800
4
13

thanks B. kocaman :-) It worked for me – unknownbits Apr 16 '16 at 11:35

score -2 · Answer 2 · answered Apr 16 '16 at 11:14

-2

Normally you would use the following code:

date('Y-m-d H:i:s', strtotime($date.' '.$time));

If it returns the year 1970, then the input date (the one from $date variable) is not formatted according to a standard that can be recognised by php.

answered Apr 16 '16 at 11:14

Ibrahim

2,034
15
22

convert Y/M/d H:i to db format in php

2 Answers2