FAQ Database Discussion Community


How to Convert a Time to local Time in Different TimeZone

c#,asp.net,asp.net-mvc,timezone,timezoneoffset
Currently i am working on a chat project from where many users can communicate through each other sitting across the globe. ie: Different TimeZone. eg. 1st in India 2nd in America 3rd in Russia 4th in Australia I am saving my message sent time into database as DateTime.Now.ToUniversalTime() Issue i...

Java- get converted date from timezone offset and date

java,datetime,timezone,timezoneoffset
My client told me that he will provide me timezone offset and date. I need to converted date in GMT accordingly. I am not sure If I am correct side or not. I think offset means how many hours up and down from GMT and after getting that apply that...

DateTimeOffset parse and custom time zone

c#,timezone,timezoneoffset,datetimeoffset
We are parsing XML DateTime values into a DateTimeOffset value. According to the W3C XSD documentation for DateTime, the type may have a timezone info or not. Our requirment says: If time zone info is provided in XML, use this time zone If no time zone info is provided, assume...

Convert datetime to string always defaults to system time zone offset, Need to get the users timezone offset in the result

c#,timezone,offset,timezoneoffset,format-string
I have a code where the user enters the DateTime and the timezone in which the dates needs to be converted to and the format in which the end date should be. Below is the code. The code converts the DateTime perfectly to the timezone the user has entered but...

How to get daylight savings start and end for a time zone in Dynamics CRM?

javascript,datetime,dynamics-crm,dst,timezoneoffset
In CRM Online 2013, I need to determine the start and end dates of daylight savings time based on a specific time zone. I have code that needs to display times converted for different time zones, aside from the time zone in the current user's settings. For example, if the...

Logstash timestamp issue - the parsed value is one hour behind the log value

timestamp,logstash,timezoneoffset
I am using the following code to read McAfee Logs ( I chose to use CSV filters because grok filters turned out to be messy) input { stdin{} } filter { csv { columns => ["timestamp", "McAf_ThreatSeverity", "McAf_Event", "McAf_EventDescription", "McAf_EventCategory", "McAf_ThreatT$ separator => "|" } date { locale => "en"...

Converting time zones within time series

r,time,timezone,time-series,timezoneoffset
I brought in a time series into R using the parse_date_time function in the library(lubridate) and I brought it in as EST. streamflowDateTime<-parse_date_time(streamflowDateTime,"%m%d%Y %H%M",tz="EST") However, the data experiences DST on 04-03-2005 01:45 and the next time step is 03:00. I want to convert this occurrence and all the time stamps...