[dba-SQLServer] SQL Server date functions

jwcolby jwcolby at colbyconsulting.com
Tue Mar 18 12:50:17 CDT 2008

I am pulling a TopN kind of thing and marking those records with GetDate()
which places a date and time in a date field.  Now I want to pull all the
records with today's date.  The first problem is that GetDate() pulls the
date and time.  The second problem is what to place in the filter.  I am not
finding a date() kind of thing like you have with Access.

How do I pull all records with today's date in a date field (that also
contains the time)?

John W. Colby
Colby Consulting

More information about the dba-SQLServer mailing list