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