P
Paul
I need a way to write a view that will select all the records posted since
midnight of the current date. The table uses a datetime field that contains
the exact time a record was added. The best I've been able to do is to pull
the last 24 hours by using;
SELECT *
FROM visits
WHERE (visitdate > CONVERT(DATETIME, GETDATE() - 1, 103))
I need to only view records since midnight if at all possible. Can you help
me adjust the query?
Thanks.
Paul
midnight of the current date. The table uses a datetime field that contains
the exact time a record was added. The best I've been able to do is to pull
the last 24 hours by using;
SELECT *
FROM visits
WHERE (visitdate > CONVERT(DATETIME, GETDATE() - 1, 103))
I need to only view records since midnight if at all possible. Can you help
me adjust the query?
Thanks.
Paul