Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. builtin login control

builtin login control

Scheduled Pinned Locked Moved ASP.NET
asp-netdatabasehelp
8 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N Offline
    N Offline
    NidhiKanu
    wrote on last edited by
    #1

    Hi all, I am using built in login control,using this data save in aspnet_Users table in database.In this aspnet_Users table one field is there i.e. LastActivityDate. Now problem is that when i login for any user at 4:30 pm ,lastactivitydate save current date with time of morning about 11. do any one know why its happen N!dh! :)

    V 1 Reply Last reply
    0
    • N NidhiKanu

      Hi all, I am using built in login control,using this data save in aspnet_Users table in database.In this aspnet_Users table one field is there i.e. LastActivityDate. Now problem is that when i login for any user at 4:30 pm ,lastactivitydate save current date with time of morning about 11. do any one know why its happen N!dh! :)

      V Offline
      V Offline
      Venkatesh Mookkan
      wrote on last edited by
      #2

      Time might be UTC time.

      Castle Rider

      What if I freeze??? Don't forget to breath...

      My: Website | Yahoo Group | Blog Spot

      N 1 Reply Last reply
      0
      • V Venkatesh Mookkan

        Time might be UTC time.

        Castle Rider

        What if I freeze??? Don't forget to breath...

        My: Website | Yahoo Group | Blog Spot

        N Offline
        N Offline
        NidhiKanu
        wrote on last edited by
        #3

        i m not getting wat do u want to say,if its UTC time then from where we can make these updation. N!dh! :)

        A 1 Reply Last reply
        0
        • N NidhiKanu

          i m not getting wat do u want to say,if its UTC time then from where we can make these updation. N!dh! :)

          A Offline
          A Offline
          Ashutosh Phoujdar
          wrote on last edited by
          #4

          The updates are according to UTC timing. If you will compare : It is saying 11:00 in place of 4:30. Means there is exact difference of 5:30 Hrs. This is still accurate if you are doing updates according to IST (UTC + 5:30). UTC was formerly known as Greenwich mean time (GMT). I Hope I answered your question. :) Thanks Ashu

          dnpro "Very bad programmer"

          N 1 Reply Last reply
          0
          • A Ashutosh Phoujdar

            The updates are according to UTC timing. If you will compare : It is saying 11:00 in place of 4:30. Means there is exact difference of 5:30 Hrs. This is still accurate if you are doing updates according to IST (UTC + 5:30). UTC was formerly known as Greenwich mean time (GMT). I Hope I answered your question. :) Thanks Ashu

            dnpro "Very bad programmer"

            N Offline
            N Offline
            NidhiKanu
            wrote on last edited by
            #5

            Hi Ashu I got this thing,but i m not asking about why this difference,I m asking about how this difference is there. My database is on same server where my application code reside,if that server is using GMT+5:30 then why its save in database in UTC.its save that date automatically so is there any way to update this date format for database. N!dh! :)

            A V 2 Replies Last reply
            0
            • N NidhiKanu

              Hi Ashu I got this thing,but i m not asking about why this difference,I m asking about how this difference is there. My database is on same server where my application code reside,if that server is using GMT+5:30 then why its save in database in UTC.its save that date automatically so is there any way to update this date format for database. N!dh! :)

              A Offline
              A Offline
              Ashfield
              wrote on last edited by
              #6

              NidhiKanu wrote:

              its save that date automatically

              So you need to look at what the default for the column is. Assuming SQL Server, getdate() will give you the local date and time.

              Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

              1 Reply Last reply
              0
              • N NidhiKanu

                Hi Ashu I got this thing,but i m not asking about why this difference,I m asking about how this difference is there. My database is on same server where my application code reside,if that server is using GMT+5:30 then why its save in database in UTC.its save that date automatically so is there any way to update this date format for database. N!dh! :)

                V Offline
                V Offline
                Venkatesh Mookkan
                wrote on last edited by
                #7

                Have you return any special code for handling the Login operation? I believe the control itself doing that. It uses its one provider which stores the data in UTC timing. You just use CultureInfo to convert to the local timing.

                Castle Rider

                What if I freeze??? Don't forget to breath...

                My: Website | Yahoo Group | Blog Spot

                N 1 Reply Last reply
                0
                • V Venkatesh Mookkan

                  Have you return any special code for handling the Login operation? I believe the control itself doing that. It uses its one provider which stores the data in UTC timing. You just use CultureInfo to convert to the local timing.

                  Castle Rider

                  What if I freeze??? Don't forget to breath...

                  My: Website | Yahoo Group | Blog Spot

                  N Offline
                  N Offline
                  NidhiKanu
                  wrote on last edited by
                  #8

                  I have not written any code for saving this data in database,one more confusion is there that how to use CultureInfo for changing TimeZone N!dh! :)

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups