Sql Server Where Clause Timestamp As Date

Date Time Data Type of SQL Server /*Getting the current system datetime*/ SELECT SYSDATETIME ,SYSDATETIMEOFFSET ,SYSUTCDATETIME ,CURRENT_TIMESTAMP ................
................