how to convert date format to datetime format using php

Question

It is not work for me, i want to convert date format to datetime of mysql format using php.i have try to obtain through the below code.what is wrong with my code

    $travelDatesconv=strtotime($travelDate);       //15/03/2015

         $travelDates=date('Y-m-d H:i:s',strtotime($travelDatesconv));

            echo $travelDates."=>uu";        
          //i need 2015-03-15 00:00:00

what is the result in `$travelDate` ? – I'm Geeker Feb 20 '15 at 08:06 — I'm Geeker, Feb 20 '15 at 08:06
15/03/2015 output => 1970-01-01 05:30:00=>uu – Udaya Ravi Feb 20 '15 at 08:08 — Udaya Ravi, Feb 20 '15 at 08:08
check the code i have updated – I'm Geeker Feb 20 '15 at 08:11 — I'm Geeker, Feb 20 '15 at 08:11

score 3 · Accepted Answer · answered Feb 20 '15 at 08:20

3

Why don't you use the DateTime object in PHP (http://php.net/manual/en/class.datetime.php)?

Here is how i would do it:

$date = DateTime::createFromFormat('d/m/Y', $travelDate);
echo $date->format('Y-m-d H:i:s');

Hope it helps.

answered Feb 20 '15 at 08:20

Eric D.

366
1
2
8

Adrian Cid Almaguer · Answer 2 · 2015-02-20T08:19:43.847

2

eliminate ."=>uu" and strtotime do not work with the format 15/03/2015 you must change $travelDate something like '03/15/2015'

$travelDate = '03/05/2015';
$travelDates = date('Y-m-d H:i:s',strtotime($travelDate));
echo $travelDates;

edited Feb 20 '15 at 08:19

answered Feb 20 '15 at 08:10

Adrian Cid Almaguer

7,815
13
41
63

score 1 · Answer 3 · answered Feb 20 '15 at 08:11

1

Check the code

$travelDatesconv=strtotime($travelDate);       //15/03/2015
 $travelDates=date('Y-m-d H:i:s',strtotime($travelDatesconv));
 echo $travelDates;        
 //Result 2015-03-15 00:00:00

answered Feb 20 '15 at 08:11

I'm Geeker

4,601
5
22
41

score 0 · Answer 4 · answered Feb 20 '15 at 08:10

0

Try following code,

$travelDatesconv=strtotime($travelDate);       //15/03/2015

    $travelDates=date('Y-m-d H:i:s',$travelDatesconv);

    echo $travelDates."=>uu";

Hope this will help you

answered Feb 20 '15 at 08:10

Elby

1,624
3
23
42

what's different to your code and me..bro – Udaya Ravi Feb 20 '15 at 08:11
@UdayaRavi check this line $travelDates=date('Y-m-d H:i:s',$travelDatesconv); – Elby Feb 20 '15 at 08:12

score 0 · Answer 5 · edited May 15 '15 at 20:50

0

$travelDate = '15/03/2015';

$date        = DateTime::createFromFormat('d/m/Y H:i:s', "$travelDate 00:00:00");
$travelDates = $date->format('Y-m-d H:i:s') . "=>uu";

echo $travelDates . PHP_EOL;

Output:

2015-03-15 00:00:00=>uu

edited May 15 '15 at 20:50

Adrian Cid Almaguer

7,815
13
41
63

answered Feb 20 '15 at 08:14

mhall

3,671
3
23
35

how to convert date format to datetime format using php

5 Answers5