SELECT DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0)
Convert(date, getdate())
SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
use this . select cast(GETDATE() as date)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)