Its no secret that Windows Azure Roles, Services and SQL Database Time Zones are set to
UTC (Coordinated Universal Time). Forgetting this fact can get us in trouble! When we forget about
Time Zones, any operations dealing with dates and times are potential bugs!
- Scheduling jobs
- Comparing dates and times
- Performing operations on dates and times
- Parsing string dates and times from the client
- Storing dates and times in SQL Database
We naturally refer to time using our current Time Zone. Imagine that a system requires a specific Job to run every Monday at 16h05 GMT –5. Its very likely that I will create a new DateTime instance that represents 16h05 and that I will happily use it to schedule my daily Job.
View original post 402 more words