Date time conversion in javascript and php

Question

I am getting different time conversions while using a datetimepicker in js and converting the date in php

My PHP code is:

<?php
    date_default_timezone_set('Asia/Calcutta');
    echo date('Y-m-d H:i:s A',strtotime('5/29/2013 00:00PM'));
    //outputs 1970-01-01 05:30:00 AM
    //echo date('Y-m-d H:i:s A',strtotime('5/29/2013 0:00AM'));//same result
    //tested on http://writecodeonline.com/php/
?>

And js

<script>
    var s='5/29/2013 0:00PM';
    parseDate= function(s) {
        var currentYear, currentMonth, currentDay, currentHour, currentMinute;
        arr=s.split(' ');
        dateArr=arr[0].split('/');
        currentYear=dateArr[2];
        currentMonth=parseInt(dateArr[0])-1;
        currentDay=dateArr[1];
        timeArr=arr[1].split(':');
        currentHour=timeArr[0];

        if(s.contains('AM')===false)
        {
            currentHour=parseInt(timeArr[0])+12;
            currentMinute=parseInt(timeArr[1].replace('PM'));
        }
        else
        {
            currentMinute=parseInt(timeArr[1].replace('AM'));
        }
        console.log(currentYear,currentMonth,currentDay,currentHour,currentMinute,0,s.contains('AM'));
        return new Date(currentYear,currentMonth,currentDay,currentHour,currentMinute,0);

    }
    console.log(new Date());
    alert(parseDate(s));
    //outputs Wed May 29 2013 12:00:00 GMT+0530 (India Standard Time)
</script>

Fiddle http://jsfiddle.net/36vjH/

gries · Accepted Answer · 2013-05-29 07:58:51Z

1

Thats because strtotime does not support your format ('5/29/2013 00:00PM');

Try: strtotime('2013-5-29 00:00:00); or http://www.php.net/manual/en/datetime.createfromformat.php instead.

answered May 29, 2013 at 7:58

gries

1,1426 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Rohan Kumar Over a year ago

So how do I convert the string in strtotime compatible in php?

gries Over a year ago

as i mentioned you can use php.net/manual/en/datetime.createfromformat.php this method

Rohan Kumar Over a year ago

Like $d=DateTime::createFromFormat('m/d/Y H:iA','5/29/2013 0:00:PM'); echo $d->format("Y-m-d H:i:s"); Great Thing

Armali Over a year ago

It is not true that strtotime does not support the format mm/dd/y hh:MMmeridian; it's just that the values have to be in the licit ranges.

Armali · Accepted Answer · 2013-05-29 08:31:47Z

1

The time '00:00PM' is malformed; as documented, an hour hh with meridian has the format "0"?[1-9] | "1"[0-2], i. e. not zero, but one to twelve.

answered May 29, 2013 at 8:31

Armali

19.6k15 gold badges64 silver badges185 bronze badges

Comments

Community · Accepted Answer · 2023-11-17 20:29:45Z

0

This extract from the PHP manual might be relevant:

"Dates in the m/d/y or d-m-y formats are disambiguated by looking at the separator between the various components: if the separator is a slash (/), then the American m/d/y is assumed; whereas if the separator is a dash (-) or a dot (.), then the European d-m-y format is assumed. "

(https://www.php.net/manual/en/function.strtotime.php)

edited Nov 17, 2023 at 20:29

CommunityBot

11 silver badge

answered May 29, 2013 at 8:19

GreybeardTheUnready

2651 gold badge5 silver badges16 bronze badges

Collectives™ on Stack Overflow

Date time conversion in javascript and php

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related