• I found a solution on google:

    SELECT DATEADD(dd, DATEDIFF(dd,0,@x), 0)

    but that seems odd to do datediff and dateadd to get the result.

    I wish there was a built in function for that.