datetime column issue

Originally Posted 30 August 2016, 6:38 pm EST

  • Originally Posted 30 August 2016, 6:38 pm EST

    we are implemented the wijmo3 grid in MVC framework .The dateTime column in our grid not showing the actual output from database.shows local timezone added value in the grid.we want to avoid this.how can we do this?we want an immediate reply..plzz help
  • Reply

    Hi,
    Apologies for the late reply, can you elaborate on how are you setting up the column?
    You can try setting the datatype of the column as shown here:http://wijmo.com/docs/wijmo/ColumnDataType.html
    Are they using custom editors? If yes, are you setting any dateFormat?
    How to set up custom editors can be checked out here:
    http://demos.wijmo.com/WidgetExplorer/explore.html?widget=Grid&sample=Custom%20Editors

    It is hard to comment without seeing the code, can you share a sample\code replicating the issue?
  • Reply

    procedure returning a date time field with value as follows

    Flowers -> 2016-08-30 07:28:10.900

    Fruits -> 2016-08-30 09:27:19.493

    Application is hosted in my pc.

    My grid is showing the result as

    Flowers -> 30 Aug 2016 7:28

    Fruits -> 30 Aug 2016 7:28

    If it is accessed from another pc, with hosted url, it’s showing another date. It seems that the grid is adding my local pc’s offset and accessed pc’s offset to this date. My PC time zone in ‘UTC-12:00 International Date Line West’. Accessed PC time zone in ‘UTC+5:30 Chennai, Kolkata, Mumbai, New Delhi’. How can I get rid of this issue? Actually we want to show the procedure output as it is, without adding any offset to it.


    we want an immediate reply...plzz reply
    2016/09/Code-1.zip
  • Marked as Answer

    Reply

    Thanks for sending the sample code, we will get back to you asap.
  • Reply

    Hi,

    we also need to implement the same, are you able to achieve this. if Yes, how you have handled it.

    Thanks in advance for the help.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels