How to get server side datetime using Caml query?

Question

Using caml query I get Calender Events but Time will be changes..How to get server Time zone ..This return time +5.30 hrs.

  CamlQuery camlQuery = new CamlQuery();
            camlQuery.ViewXml = "<View><Query><Where>" +
                              "<DateRangesOverlap><FieldRef Name=\"EventDate\" />" +
                              "<FieldRef Name=\"EndDate\" />" +
                              "<FieldRef Name=\"RecurrenceID\"/>" +
                              "<Value Type=\"DateTime\"><Month /></Value></DateRangesOverlap>" +
                              "</Where></Query></View>";

  ListItemCollection collListItem = oList.GetItems(camlQuery);

            clientContext.Load(collListItem);


            clientContext.ExecuteQuery();
  foreach (ListItem oListItem in collListItem)
            {

                var Title = oListItem["Title"] != null ? oListItem["Title"].ToString() : "";
                var EventDate = oListItem["EventDate"] != null ? oListItem["EventDate"].ToString() : "";
                var EndDate = oListItem["EndDate"] != null ? oListItem["EndDate"].ToString() : "";
                var Location = oListItem["Location"] != null ? oListItem["Location"].ToString() : "";
                var Description = oListItem["Description"] != null ? oListItem["Description"].ToString() : "";

  Calender item = new Calender();

                item.Title = Title;
                item.EventDate = Convert.ToDateTime(EventDate);
                item.EndDate =Convert.ToDateTime(EndDate);
                item.Location = Location;
                item.Description = Description;


                Result.Add(item);
}

In Calender It display date as:means start Time is 3PM to 4PM

but it return as:

Answer 1

try the below line.

 item.EventDate = TimeZone.CurrentTimeZone.ToLocalTime(EventDate);

Answer 2

I had seen many a times people are struggling with DateTime field in SharePoint. SharePoint internally store DateTime filed into UTC format.

So to solve your problem you need to convert the UTC time in accordance with your sever time zone. You can get the web time zone using SPWeb object. Following is the property you need to use.

SPWeb.RegionalSettings.TimeZone

Also if you are using CSOM C# then you need to refer to Web object instead of SPWeb.