sienteasturias
New Member
I have a C# time application where the user can create a timer and start it, it will do something like that on the server
the dates are stored in CEST (the problem is summer and winter time))\[code\]// insert into dbvar entry = new TimeEntry();entry.Start = DateTime.Now; (04/03/2013 12:00)_timeEntries.Add(entry); // => now it's in the db\[/code\]if he stops it then it do something like that:\[code\]// update the entryvar entry = _timeEntries.Get(1) // 1 is the id from the created entry beforeentry.End = DateTime.Now; (04/03/2013 12:37)_timeEntrires.Update(entry); // => now it updates it in the db\[/code\]Something like that will be shown for the user in the browser:TimerId: 1Start: 04/03/2013 12:00Stop: 04/03/2013 12:25Total (in min): 25Now I think there will be some problems when the user changes his timezone.What's the best way to solve this? Store the dates as UTC and then convert with JavaScript?Thanks for your helps .
the dates are stored in CEST (the problem is summer and winter time))\[code\]// insert into dbvar entry = new TimeEntry();entry.Start = DateTime.Now; (04/03/2013 12:00)_timeEntries.Add(entry); // => now it's in the db\[/code\]if he stops it then it do something like that:\[code\]// update the entryvar entry = _timeEntries.Get(1) // 1 is the id from the created entry beforeentry.End = DateTime.Now; (04/03/2013 12:37)_timeEntrires.Update(entry); // => now it updates it in the db\[/code\]Something like that will be shown for the user in the browser:TimerId: 1Start: 04/03/2013 12:00Stop: 04/03/2013 12:25Total (in min): 25Now I think there will be some problems when the user changes his timezone.What's the best way to solve this? Store the dates as UTC and then convert with JavaScript?Thanks for your helps .