LastloginDate column in aspnet_Membership table

Last post 05-18-2008 3:27 PM by amensi. 3 replies.

Sort Posts:

  • LastloginDate column in aspnet_Membership table

    05-14-2008, 3:07 PM

    Hi;

    I use  of login control in my application and i login and date,time was store in LastloginDate column.

    but  time was stored  to not  equal to time system.

    Why time  LastloginDate column  is more little as time system?

    versatility  is 3 hours.

    Thanks,mohsen

  • Re: LastloginDate column in aspnet_Membership table

    05-14-2008, 3:59 PM
    • Loading...
    • amensi
    • Joined on 02-13-2006, 7:43 PM
    • Canada
    • Posts 379

    Hi,

    The LastLoginDate property that is stored in this column is in UTC time format. Therefore if your are in a GMT -3 time zone you need to make the proper adjustment when retrieving this value.

     Ciao,

    Alex Mensi - Check out my blog
    Maven Technologies Inc.
    --

    Don't forget to click "Mark as Answer" on the post that helped you.
  • Re: LastloginDate column in aspnet_Membership table

    05-15-2008, 4:22 AM

    Hi amensi :

    Please more explain about UTC time format.

    Thanks,mohsen  

  • Re: LastloginDate column in aspnet_Membership table

    05-18-2008, 3:27 PM
    Answer
    • Loading...
    • amensi
    • Joined on 02-13-2006, 7:43 PM
    • Canada
    • Posts 379

    UTC time is the GMT universal time zone. For example, i live in montreal Canada therefore my timezone is GMT -5 or 5 hours behind UTC. So if my login time is 17h00(GMT-5) ASP will store the login time as 12h00.

    Alex Mensi - Check out my blog
    Maven Technologies Inc.
    --

    Don't forget to click "Mark as Answer" on the post that helped you.
Page 1 of 1 (4 items)