I'm using SQL Server to
some data which originates from a HTML table. I want to
total rows in the database based on today's date. And then after the date hits tomorrow's date, to set the
value back to zero and to restart the count back from the start.
Is there a query that can help me fetch data based on current date and time?
Something like this:
WHERE clock_time BETWEEN 000000 AND 235959
AND date_time IS TODAY's DATE (or something like that)
GROUP BY XXX
ORDER BY XXX
After the clock hits tomorrow's date, I want to reset the
back to zero, and to start a new count back from 00:00:00.
I know there is
query but as far as I know it only shows the date.
Someone told me I could use
but the SQL Server won't work with that.