<p>I am writing a program that needs to send out an email every hour on the hour, but at a time local to the user.</p>

<p>Say I have 2 users in different time zones. John is in New York and Fred is in Los Angeles. The server is in Chicago. If I want to send an email at 6 PM local to each user, I'd have to send the email to John at 7 PM Server time and Fred at 4 PM Server time.</p>

<p>What's a good approach to this in .NET / Sql Server? I have found an xml file with all of the time zone information, so I am considering writing a script to import it into the database, then querying off of it.</p>

<p><strong>Edit:</strong> I used “t4znet.dll” and did all comparisons on the .NET side.</p>

[{'answer_id': 63983, 'author': 'Gibbons', 'author_id': 1506, 'author_profile': 'https://Stackoverflow.com/users/1506', 'pm_score': 1, 'selected': False, 'text': '<p>If you access an intranet Web site by using an IP address or a fully qualified domain name , or a url with a dot in it the Web site may be identified as in the Internet zone instead of in the Local intranet zone.</p>\n\n<p><a href="http://support.microsoft.com/kb/303650" rel="nofollow noreferrer">http://support.microsoft.com/kb/303650</a></p>\n'}, {'answer_id': 178033, 'author': 'Jonathan Works', 'author_id': 309844, 'author_profile': 'https://Stackoverflow.com/users/309844', 'pm_score': 1, 'selected': False, 'text': '<p>You may also want to try having your users add your domain to their trusted sites list. I know that I had to do that to get our sites working with NTLM.</p>\n'}, {'answer_id': 429683, 'author': 'Andrew Hampton', 'author_id': 466, 'author_profile': 'https://Stackoverflow.com/users/466', 'pm_score': 1, 'selected': True, 'text': '<p>Turned out that the new security settings on the laptops required NTLMv2 which is not well supported by the JCIFS NLTM library.</p>\n\n<p>After some research, found out that JCIFS implementation of NTLM is very hacky (as described by the JCIFS devs) and they\'re removing support in the next major version of JCIFS.  We\'ve moved to using the Tomcat IIS Connector (<a href="http://tomcat.apache.org/connectors-doc/webserver_howto/iis.html" rel="nofollow noreferrer">http://tomcat.apache.org/connectors-doc/webserver_howto/iis.html</a>), which works <em>much</em> better.</p>\n\n<p>Thanks everyone for your responses.</p>\n'}]
['https://Stackoverflow.com/questions/22319', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/26/']