Previous Thread:   Senior Applications Developer Springfield, MA

9/30/2005 11:52:49 AM    Date Time settings in ASP.NET State Database
Greetings,  
  
I am using SQL Server for state management in an ASP.NET application.  
  
The ASPStateTempSessions table is being stored in the ASPState table  
  
(and not the SQL Temp database).  
  
I am curious as to the date/time format being used to store the Created  
  
and the Expires column data.  
  
The date/time values in these two columns is always 4 hrs. ahead of my  
  
current time (as per the time zone settings in Windows).  
  
Where is ASP.NET getting this date/time from?  
  
I have checked the Regional Settings and the Time Zone settings on the  
  
server and everything is set correctly.  
  
The LockDateLocal date/time values, on the other hand, are correct.  
  
So where does ASP.NET get the date/time settings for the Created and  
  
Expires column?  
  
Am I smoking crack or has someone else ever looked into that database?  
  
Thanks.  
  
-Harold