joined:June 29, 2005
Real quick question here, hopefully someone can point me in the right direction.
I've got a very simple ASP.NET 4 web application that implements forms authentication, using SQL Server as the membership provider.
Everything works perfectly, but I've just noticed that the internal dates in the Membership tables (LastLoginDate, LastPasswordChangedDate, etc) are an hour behind. For example, it's 12.27pm at the moment, but if I log in, the date updated will be 11.27am.
The clock on the server is correct, the SQL command getdate() returns the correct date, everything looks fine. I guess this is a daylight savings issue, but does anyone have any idea as to where the dates are getting mixed up?