>>Hi Tim,
>>
>>Your assumption is incorrect. SQL Server 2005 doesn't have timezone aware datetime data types. It saves whatever datetime value it gets. IOW, if conversion occurs, it occurs in your application.
>
>Thanks Sergey,
>I will see what I can figure out in the application then.

Hi Tim,

When I said "your application", I also meant whatever technology your application uses to interact with SQL Server (ADO.NET, etc.)