SELECT count(id) FROM users WHERE DATEDIFF(eventtime,GETDATE(),d) == 1;
Or something along those lines, all the date functions are very well
documented in the "digital books" that come with Enterprise Manager.
Open up the reference, and search for datediff, and there should be a
link in there for
I've used mysql a little, but now I'm working with a MS SQL SERVER 2000
database. We have a proprietary application/hardware setup where
when a person enters the building, the time they enter the building
is automatically put into the database in a field called eventtime, and
their access card
Getting this error:
Warning: MS SQL message: Unicode data in a Unicode-only collation or ntext data cannot
be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.
(severity 16) in C:\webroot\test.php on line 13
Warning: MS SQL: Query failed in C:\webroot\test.php on
