SQL Date functions

I always forget this so its here forever!

This is how to get the current Date..


CONVERT(varchar(8), GETDATE(), 112)

This is how to get the date from a datetime field


CONVERT(varchar(8), *InsertFieldHere*, 112))

Select queery to get the recoreds from a dateTime field for today..


SELECT     *
FROM         *Table*
WHERE     (CONVERT(varchar(8), GETDATE(), 112) == CONVERT(varchar(8), *InsertFieldHere*, 112)) ORDER BY Datetime