Treat SQL Server's datetime value as UTC?

[NewsBot]

I have a SQL Server DateTime* column in a table that I want to use AS a UTC DateTime value in .Net.

For example:

Table = Events
Column = StartTime (datetime) = 4/31/2008 13:00:00

....

and I want it to eventually become a UTC time of that exact value...

of 4/31/2008 13:00:00...

But ADO.net wants to use the the SQL server (or Web server) timezone when I do DateTime.ToUniversalTime()...

I want the immune the app to the SQL Server / web server's timezone.

I'm sure there's a way... but how?


More...

View All Our Microsoft Related Feeds