Originally Posted 30 August 2016, 6:38 pm ESTwe 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
datetime column issue
Originally Posted 30 August 2016, 6:38 pm EST
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:
It is hard to comment without seeing the code, can you share a sample\code replicating the issue?
Replyprocedure 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
Marked as Answer
ReplyThanks for sending the sample code, we will get back to you asap.
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.