<div class="gmail_quote">On Fri, Nov 2, 2012 at 8:13 AM, <span dir="ltr"><<a href="mailto:dennisjperkins@comcast.net" target="_blank">dennisjperkins@comcast.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-size:12pt;font-family:Arial">This question concerns Windows, but maybe someone in the group knows the answer.<br><br>My company's product runs on a Windows server. Some customers want to use a time server to keep our system synchronized on their networks. The problem is that EPA regulations prohibit participating in the spring and fall time changes. The reason is that the spring change puts a one-hour gap in the data and the fall change forces overwriting an hour's worth of data. Is it possible to set up the time server and the server that our software is running on to keep the computer in sync but not do these two time changes?<br clear="all">
</div></div></blockquote><div><br>Windows normally puts both the OS and hardware clock in local time, and daylight savings resets both clocks. UNIX normally(ish) puts the hardware clock on GMT, and the OS reports whatever local time you want. Or I've been places that use GMT for everything.<br>
<br>All that said, it sounds like you store the data in your database in local time, rather than GMT and perform the adjustment in software. If you store it in GMT the server can do what it wants, as long as you can determine what the timezone is set to. You may be able to fake the funk by doing database queries by time, then sort by database index, but that's a little ugly, and you'd have to figure out how to display the data.<br>
<br>Other methods, though cleaner, probably involve database schema changes. Include the time offset from GMT, for example. But if you're storing the time without any time offset, you'll overwrite data even if you run into problems like the time server going down and the local clock drifting, then getting reset correctly.<br>
</div></div><br>-- <br>Andrew Diederich<br><a href="mailto:andrewdied@gmail.com" target="_blank">andrewdied@gmail.com</a><br>