Why CreatedDate LastPasswordChanged Date columns showing different Time Instaed of Sql Server Time

Nov 4, 2013 at 5:48 AM
Edited Nov 4, 2013 at 5:55 AM
Hi ,
i have issue after filling up the membership form i am getting the user details in aspnet_Membership table with created and lastpassword date fields are updated not based on my sql server time it showing nearly 6 hours late time why time how can i fix it
my system Time:2013-11-04 12:54:09.107
my Field (created) Im membership Table:2013-11-04 06:56:29.000
Nov 4, 2013 at 1:02 PM
The time is your system time, but it is being saved as UTC. Saving it in UTC makes it easy to convert to whatever time zone the user might be in on the front end.