Remove Timezone

[Nicholas Picardi]

HI All,

It's possible to remove timezone +01:00

because in SQL i have : 2017-01-01 00:00:00.000

and in Html.EJ().Grid<object>("FlatGrid") i have : 2017-01-01 01:00:00

It's Urgent please!!

Thanks,

Nicholas

[Saravanan Arunachalam]

Hi Nicholas, 

Thanks for contacting Syncfusion’s support. 

The date-time request on the controller is depend on the server time zone. Please refer to the following link to know more details. 

http://prideparrot.com/blog/archive/2011/9/how_to_display_dates_and_times_in_clients_timezone  

If the client and server has different timezone, the Grid content will show the date based on the client timezone. So, we suggest you to store date-time in common timezone (GMT/UTC) on the database or convert the date to UTC date format and return to the client. 

https://msdn.microsoft.com/en-us/library/system.datetime.touniversaltime(v=vs.110).aspx   

Regards, 

Saravanan A. 

[Nicholas Picardi]

Thanks,

But why on Internet Explorer this problem is not present?

[Saravanan Arunachalam]

Hi Nicholas, 

If you return the date from the server without format, it is returned as string to the client and it passes the string to the default browser date constructor. So, we suggest you to format the date while return to show the UTC timezone in all browser and please refer to the below link to get more details. 

http://codecoding.com/how-different-browsers-implement-date-function/  

Regards, 

Saravanan A. 

[Arpan Rao]

I am also stuck with same issue, can someone please post the solution here?

[Manivannan Padmanaban]

Hi Arpan, 

Greetings from Syncfusion Support. 

To overcome the reported “Time Zone” issue, we recommend that you use ej.serverTimezoneOffset property. Refer to the below code example, 

 

<script type="text/javascript">  

   . .  .  

    var serverTimeZoneDiff = -5.0  // if your server is in EST time zone (UTC -5.0) (in hours)  

    var clientSideTimeZoneDiff = new Date().getTimezoneOffset() / 60; // get client time zone difference and convert it to hours;  

    ej.serverTimezoneOffset = serverTimeZoneDiff + clientSideTimeZoneDiff;  

  

. . .  

        </script>  

Also, refer the below help documentation link. 

https://help.syncfusion.com/js/datamanager/servertimezoneoffset  

After referred the above solution, still facing an issue. Please come back to us, with the below details. 

1. Share the complete grid code example (both client and server end)
2. Share the screenshot Or video demonstration of the issue.

Provided details,  will help us to resolve the reported issue as early as possible. 

Regards, 

Manivannan Padmanaban