Advanced Search

Return to Snippet

Revision: 66022
at February 28, 2014 03:56 by kidmizere
Initial Code 
-- edit tbl.datecolumn to reflect required column

WHERE tbl.datecolumn >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) AND tbl.datecolumn < DATEADD(day, DATEDIFF(day, 0, GETDATE()), 1)
Initial URL 









Initial Description





This is the best method for querying a table to get data where a date column needs to equal today:









Initial Title





MSSQL where date=today









Initial Tags














Initial Language





SQL