Server Timezone Offset in JavaScript DataManager

18 Apr 20235 minutes to read

This property is used to set the time-zone offset from UTC, in hours

Property

Name:	ej.serverTimezoneOffset
Data type:	number
Default Value:	0

NOTE

Suppose, application has been hosted in EST time zone and client may be in IST, GMT etc. in that case, date will differ from database. The below given solution will fix the conflict.

Time-zone offset calculation from UTC:
ej.serverTimezoneOffset = serverTimeZoneDiff(in hours) + ClientSideTimeZoneDiff(in hours);

HTML

<div class="content-container-fluid">
        <div class="row">
            <div class="cols-sample-area">
                <div id="Grid"></div>
            </div>
        </div>
    </div>
    <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;
        $(function () {
            var dataManager = ej.DataManager({ url: "http://mvc.syncfusion.com/services/Northwnd.svc/Orders" });
            $("#Grid").ejGrid({
                dataSource: dataManager,
                allowPaging: true,
                columns: ["OrderID", "EmployeeID", "CustomerID", "OrderDate", "Freight"]
            });
        });
    </script>

NOTE

By default, The server time zone will be in UTC, hence server time-zone offset value for UTC is zero. if its other than the UTC, set the proper format time zone offset value to the ej.serverTimezoneOffset property.

Please refer the online link for time zone offset values.

The countries that are using Eastern Standard Time (EST) when observing standard time (autumn/winter) are 5 hours behind Coordinated Universal Time (UTC−05:00).

Eastern Daylight Time (EDT), when observing daylight saving time DST (spring/summer) is 4 hours behind Coordinated Universal Time (UTC−04:00).

NOTE

When the Daylight saving time mode is enabled in the server, take care about this time adjustment with the server time-zone offset calculation.

Let see an example, when they observe the Daylight saving time.

HTML

<div class="content-container-fluid">
        <div class="row">
            <div class="cols-sample-area">
                <div id="Grid"></div>
            </div>
        </div>
    </div>
    <script type="text/javascript">
        var serverTimeZoneDiff = -4.0  // if your server is in EDT time zone (UTC -4.0) (in hours)
        var clientSideTimeZoneDiff = new Date().getTimezoneOffset() / 60; // get client time zone difference and convert it to hours;
        ej.serverTimezoneOffset = serverTimeZoneDiff + clientSideTimeZoneDiff;
        $(function () {
            var dataManager = ej.DataManager({ url: "http://mvc.syncfusion.com/services/Northwnd.svc/Orders" });
            $("#Grid").ejGrid({
                dataSource: dataManager,
                allowPaging: true,
                columns: ["OrderID", "EmployeeID", "CustomerID", "OrderDate", "Freight"]
            });
        });
    </script>