Gridview updating database
Since the date/time is stored in server time, Bob's previous order still shows that it was made on August 1 2007 at AM.
Such auto-entered timestamp values can be stored in the database in either server time or Coordinated Universal Time (UTC).
If you use SQL Server's built-in property to determine the current time, then you are using server time and saving the date and time respective to the web or database server's time zone settings.
Alternatively, if you use SQL Server's built-in property then you are storing the values in UTC.
There are a number of advantages in storing such date/time values in UTC rather than server time.
Other challenges of date/time values include displaying dates relative to one's time zone and daylight savings.