columntype : 'datetimeinput' issue

[anandbabuParticipant]

HI jqwidget team,
Hi am using columntype : ‘datetimeinput’ and my cellFormat:’MMM yyyy’ in my grid and also i storing the date into database.
Addition information i am using oracle database and Spring 3.0(java)
Issues:
1.In IE the values are coming like 2014-07-01 00:00:00.0 even though i giving cellFormat ‘MMM yyyy’ but it working fine chrome (Jul 2014).
2.If i try to save the date value in IE dates are going correctly but in chrome its going as one day before(i.e) if i alert the records in UI dates are coming proper then if i sending date value to my java controller method and print this value it showing one day before(e.g)
if my date value is jul 2014 and in java method it showing as 2014-06-30T18:30:00.000Z but in IE its working fine.

[Peter StoevKeymaster]

Hi anandbabu,

jQWidgets works with JavaScript Date Objects. You can learn about JavaScript Date Objects on this page: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date. If you try to load parse Strings which does not include Time-Zone information, you will have one day differences depending on the time-zone and that is pretty normal and should be expected. So if you don’t want such differences, your server should pass to the client Date Strings with Time Zone information and then on the client side you should define your Date’s format in the data binding process. In other words, please look at the Grid’s Data Sources help topic and see how the “format” property of a “date” data field is set.

Best Regards,
Peter Stoev

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

[Author]

Posts