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.

>
>I have a web application that is connected to a SQL Server database. This SQL Sever is located in Texas and thus is Central Time. I have a C# application that is saving data to the SQL Server via a WCF application. This application saves a row with a DateTime field that indicates the time the record was created on the application. It is created with a DateTime.Now in C# at the application level. This application is running on a computer in Pacific time and the computer time is set to pacific time. The time in the SQL server is being saved in central time.
>
>I am assuming there is something in the SQL Server that is changing this time when saved. How do I override this behavior when I save the record? I want the times to be saved the way I created them.