Returns the current database system timestamp as a datetime value, derived from the operating system of the computer on which the instance of SQL Server is running
Select yesterday's data:
select * from content where datefield = GETDATE()-1