[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