Strange problem with dates in jqx grid with Safari on Mac

[pja1Participant]

We have recently noticed that datetime values in a grid when viewed in Safari on OSX appear to be changed from their original values. I have prepared a JSFiddle which demonstrates the problem.

http://jsfiddle.net/pauladler/z86LdLzc/12/

If you run this in Safari (we tested V7.1 on Mac OSX ), then the date values were changed.

eg the JSON value of “2014-12-10T10:00:00”, which is normally displayed for me in Windows FF as “Wed Dec 10 2014 10:00:00 GMT+1100 (AUS Eastern Standard Time)”, is instead displayed in Safari on OSX as Wed Dec 10 2014 21:00:00 GMT+1100 (AEDT). Note the time change.

Here is a screenshot of the output as a Safari OSX user sees it: http://prntscr.com/5fuy1g

“2014-12-10T13:00:00” becomes “Thur Dec 10 2014 00:00:00 GMT+1100 (AEDT)” in Safari OSX. Note the time/date change.

If you run this on Windows it behaves as expected. The formatting of the date changes, but the actual values do not. We’ve tested several versions of Windows and browsers

If you run it on Firefox on OSX, the date values do not change. This issue appears to only occur when running Safari on OSX.

I’m not sure what is happening here, or if we are doing something wrong, but I’d greatly appreciate your assistance.

[pja1Participant]

I wonder if this is a bug in jqxGrid (albeit one not introduced by you guys)?

[DimitarParticipant]

Hello pja1,

Date objects are automatically converted to the local time zone. In your case the issue is actually with the browsers that do not convert it. To achieve a uniform representation across all browsers, modify your data as shown here: http://jsfiddle.net/Dimitar_jQWidgets/8ahaL1mz/. This behaviour is related to the JavaScript Date object, not to jqxDataAdapter or jqxGrid.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts