Converting JSON date string to a correct Date object [duplicate]

Question

Possible Duplicate:
Help parsing ISO 8601 date in Javascript

I think this should be very simple but turned out amazingly tedious.

From WEB API, I received selected object via ajax, and one of its properties is InspectionDate datetime string such as 2012-05-14T00:00:00

In javascript, I use following code to have correct date object

selected.JsInspectionDate = new Date(selected.InspectionDate);

But JsInspectionDate shows

2012/05/14 00:00 in firefox, 
2012/05/13 20:00 in chrome and 
NAN in IE9

for 2012-05-14T00:00:00.

Could someone tell me why this problem occurs? And how to fix this issue? I just want to show as in firefox for all browsers.

Looks like a timezone problem. 4 hours difference, do you live on the East Coast? — Mike Robinson
– Mike Robinson, Commented Aug 22, 2012 at 17:25
Try new Date(selected.InspectionDate + "Z"). This fixes the timezone. But maybe this won't work on IE. — nalply
– nalply, Commented Aug 22, 2012 at 17:30

nalply · Accepted Answer · 2012-08-22 17:42:35Z

2

Do this:

new Date(selected.InspectionDate + "Z")

Rationale: Your dates are in ISO 8601 form. Timezone designators like "Z", a very short one for UTC, work.

Note! IE might not understand ISO 8601 dates. All bets are off. In this case, better use datejs.

answered Aug 22, 2012 at 17:42

nalply

29.2k15 gold badges84 silver badges105 bronze badges

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

1 Comment

Tae-Sung Shin Over a year ago

Yeah datejs was way to go. Everything is in harmony now. To be honest, I didn't know datejs was requirement. Thanks for your answer.

Tae-Sung Shin · Accepted Answer · 2012-08-22 19:12:48Z

1

Update:

First as one suggested, I tried following after referencing date.js.

selected.JsInspectionDate = Date.parse(selected.InspectionDate);

It seemed like working but later I found it was not enough since the JSON date string can have a format of 2012-05-14T00:00:00.0539 which date.js can't process either.

So my solution was

function dateParse(str) {
    var arr = str.split('.');
    return Date.parse(arr[0]);
}
...
selected.JsInspectionDate = dateParse(selected.InspectionDate);

answered Aug 22, 2012 at 19:12

Tae-Sung Shin

20.7k34 gold badges144 silver badges248 bronze badges

Comments

Ashirvad · Accepted Answer · 2012-08-22 17:55:31Z

0

FIDDLE

var selectedDate='2012-05-14T00:00:00';
var formatttedDate=new Date(selectedDate.substr(0,selectedDate.indexOf('T')));

document.write(formatttedDate.getFullYear()+'/'+(formatttedDate.getMonth()<10?'0'+formatttedDate.getMonth():formatttedDate.getMonth())+'/'+formatttedDate.getDay());

answered Aug 22, 2012 at 17:55

Ashirvad

2,3771 gold badge16 silver badges20 bronze badges

1 Comment

nalply Over a year ago

This discards the time part. And why reinvent the wheel?

Collectives™ on Stack Overflow

Converting JSON date string to a correct Date object [duplicate]

3 Answers 3

1 Comment

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Linked

Related