I'm working on a project where I have to gather data from GPS devices located in different countries (timezones + daylight savings) and display those data to different users also from different countries. I'm thinking about saving the date in UTC format (that is what I receive from the GPS device) but then again I belive I'll have trouble converting that date to the user's local date (I have to display historical data also so I'll have to account for daylight savings for the given date). Maybe the datetimeoffset datatype would be more appropriate but how would I go about converting the received UTC date to the datetimeoffset datatype? What would you suggest? Thanks!
Which SQL datatype should I use to store datetime from GPS devices?
367 Views Asked by sdagkas At
1
There are 1 best solutions below
Related Questions in SQL
- how to send email from localhost using codeigniter?
- PowerShell EWS Save as for e-mails
- I want to develop an automated email application in asp.net with c#
- Not able to send email in java using SMTP,its blocked by firewall in my office.Is there any other method by which we can send mail?
- Postfix - cannot connect to server to receive email
- PHPMailer send mail with array ( $_POST['email'] )
- Could Not Instantiate Mail Function - PHPMailer - With Attachments - Only Google Chrome
- encrypted email with entrust certificate is not opening with MS Outlook
- Disconnect Client connected to cgi application
- send a message using freemarker
Related Questions in GPS
- how to send email from localhost using codeigniter?
- PowerShell EWS Save as for e-mails
- I want to develop an automated email application in asp.net with c#
- Not able to send email in java using SMTP,its blocked by firewall in my office.Is there any other method by which we can send mail?
- Postfix - cannot connect to server to receive email
- PHPMailer send mail with array ( $_POST['email'] )
- Could Not Instantiate Mail Function - PHPMailer - With Attachments - Only Google Chrome
- encrypted email with entrust certificate is not opening with MS Outlook
- Disconnect Client connected to cgi application
- send a message using freemarker
Related Questions in UTC
- how to send email from localhost using codeigniter?
- PowerShell EWS Save as for e-mails
- I want to develop an automated email application in asp.net with c#
- Not able to send email in java using SMTP,its blocked by firewall in my office.Is there any other method by which we can send mail?
- Postfix - cannot connect to server to receive email
- PHPMailer send mail with array ( $_POST['email'] )
- Could Not Instantiate Mail Function - PHPMailer - With Attachments - Only Google Chrome
- encrypted email with entrust certificate is not opening with MS Outlook
- Disconnect Client connected to cgi application
- send a message using freemarker
Related Questions in DATETIMEOFFSET
- how to send email from localhost using codeigniter?
- PowerShell EWS Save as for e-mails
- I want to develop an automated email application in asp.net with c#
- Not able to send email in java using SMTP,its blocked by firewall in my office.Is there any other method by which we can send mail?
- Postfix - cannot connect to server to receive email
- PHPMailer send mail with array ( $_POST['email'] )
- Could Not Instantiate Mail Function - PHPMailer - With Attachments - Only Google Chrome
- encrypted email with entrust certificate is not opening with MS Outlook
- Disconnect Client connected to cgi application
- send a message using freemarker
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
As you don't have to store any time zone along with the datetime, you can store them as UTC. That has the advantage of being linear, and easy to document. You don't have to bother with gaps and overlaps at the daylight savings time switches.
Convert the date to the local time zone when you display it to the user. It doesn't make sense to convert it to a local time zone until you know which user will be viewing the data.