Mar 202009
 

I wanted to get all of the rows that were time stamped today from a table that has a datetime column.

Here is the query that I used:

SELECT COUNT(*) AS [Today's File Count] FROM dbo.Envelope WHERE (CONVERT(varchar, entry, 101) = CONVERT(varchar, GETDATE(), 101))