set timezone in connectionstring

[ralphtrent]

Hello
I am connecting to a SQL 2005 server via a c# class. The times in the db are stored in GMT. Is there away to reques the times be converted to another timezone on my connection string?

Thanks

 

[mrdenny]

Nope. You have to do that conversion either through the T/SQL or in the client application.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[ralphtrent]

Thats what I thought, but was not hoping not to hear.

Thanks.