Security :: Time In LastLoginDate Field Ahead Of Local Server Time 3 Hours?
Mar 25, 2010
In my asp.net application I user Microsoft Membership to manage site access security and find the time saved into LastLoginDate is ahead of local time (Eastern Time Zone) 3 hours. What is wrong with it and how to ajust it to local time by application system only such as changing some properties od application?
for my web app I'm using ASP.NET's standard membership for authentication, but for some strange reason the LastLoginDate in the aspnet_Membership table has incorrect time for all my users, the date part is fine, but the time is way off (it's like 6-7 hours different from the correct time). The LastActivityDate in the aspnet_Users table is also wrong with the same kind of issue. I checked the server machine that's hosting the SQL Server and the time on there is correct, is there something else that's dictating the time?
i was just wondering how one would approach creating a link that would be active for 24 hours for a user... ie i have in the db a time of confirmation and then wanted to make a download active for them for 24 hours and deactivate it post then.
I have a date/time stored in a smalldatetime field (ms sql 2005) that i want to compare with the current time and receive a difference. If the difference is less than 30 minutes, do this....if more do that....
This is the sqlDateTime overflow problem again. Background. As I'm sure you know dates must be between 1/1/1753 and 12/31/2999. If you have an empty date field, it throws and exception. So I created a function (below) that solve the problem when attempting to update or insert a record with a date field. Works great.
Public Shared Function MakeDateField(ByVal pasDate As String) As Nullable(Of DateTime)
If IsDate(pasDate) Then Try If pasDate <= System.DateTime.MinValue Then Return Nothing Else Return CType(pasDate, DateTime) End If Catch ex As NullReferenceException Return Nothing End Try Else Return Nothing End If End Function
So I thought about using a time field. I have the field, have the validator in place and then attempted to test the page. It resulted in my least favorite error message "sqlDateTime overflow".
I can think of several workarounds like adding a date or a fixed date to the time field, or converting it to a string. Each of these is problematic.
IS THERE A BETTER WAY TO UPDATE/INSERT TIME FIELDS.
I need to do an update a field in database every x minutes. ie: a person login and I need to update a field related to they every X minutes until the value reach a value. Like this, this person start a count event from 1 to 10, they log off the web, but this count must remain countting until reachs 10, 1 by 1 every 7 minutes. I cannot do a SQL Job. Should I User a System.Timer??? Should I record the time and value of the last update, when the person log in I cauculate and update the value??
As the server of my website is located in a different timezone, is there a easy way to override the server local time by a setting in either web.config or global.asa?I could of course just use .AddHours() in all my .now() statements, but as this problem occured recently when I moved the site and that the .Now() syntax is used a number of times in the application I was looking for a another solution than changing my code everywhere I've used this syntax.
whenever I replace a master page on my site the pages load after a few hours(1-2) and only after that the site returned to work as normal.. I dont use VS "open web site" from the web method, instead I download the page I want to change (using flashfxp for instance), make my changes and upload it back. I do this process because every now and then the VS stuck/not responding/think long time. he master pages I change are used by few thousand of pages in the site, my thought is that whenever I change a master all the site get rebuild and therefor the long loading time..
When I tested my ASP.net page on the local host, the time came out exactly right. But when I uploaded everything and tested it out on the internet, it was 3 hours behind -TimeLabel.Text = Now.ToShortTimeString It's 7:44AM here, but it shows up as 4:44AM.
My web application has hosted on the canada server but my all clients are indians.So, as I am using System.datetime.Now to store all the dates in application.Obviously, it is displaying the canadian time instead of india time.How can i do it?Is there not any gloabl settings that we can do in our web.config file so that it indicates to the server at run time which time zone to execute..?Or any other suitable alternate?
I have a datetime column in my table. It has a value like this for example: 4/27/2010 7:34:00 PM. I would like to display the time part of the column in military time. So this datetime column would appear as: 4/27/2010 19:34
i have to listen my mail server for every 30 min. i have a distribution list and i want to count number of email comes for that distribution list and no of replies goes from the outlook for every 30 minutes. also i need to get the time difference between the replied time with arrived time of the mail. so show me some sample code