select * from welfare.HR_TXN_SAP_Summary

where DATEADD(day, 0, DATEDIFF(day, 0,sent_sap_date))

= cast(‘20070726’ as datetime)