[thelist] New annoying feature of SQL Server
Rob Smith
rob.smith at THERMON.com
Fri Jan 3 10:35:01 CST 2003
Hola,
Real quick, I've just started recording when and who accesses my company
Intranet via an INSERT query (in ASP 2.0):
Dim ThaTime, DateToday
ThaTime = Time
DateToday = Date
IntranetLog.Source = "INSERT INTO IntranetLog (UserID, DateAccessed,
TimeAccessed) VALUES ('" & userID & "', '" & DateToday & "', '" & ThaTime &
"')"
IntranetLog.Open()
Ok. When I go into my DB, and look at the TimeAccessed column I get this:
... ...
... 1/1/1900 9:24:09 AM
... 1/1/1900 9:25:38 AM
... 1/1/1900 9:27:01 AM
... 1/1/1900 9:34:29 AM
... 1/1/1900 9:36:28 AM
... 1/1/1900 9:43:15 AM
... 1/1/1900 9:57:19 AM
... 1/1/1900 9:29:02 AM
... 1/1/1900 10:01:13 AM
... ...
Could you help me understand why the 1/1/1900 mystery entry? And how to
prevent it?
FYI:
LogID int 4 NOT NULL
IntranetUser varchar 100
DateAccessed datetime 8
TimeAccessed datetime 8
Rob.Smith
More information about the thelist
mailing list