title: ASP.NET Date/Time Conversions
body: <p>I think I am overthinking this issue a little and I'm hoping someone can help me out. </p>
  
  <p>I have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it.  One of the pages asks for a start date and end date (no times). </p>
  
  <p>I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. </p>
  
  <p>My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. </p>
  
  <p>How can I convert  a date and time to UTC time based on the time zone of the user?</p>