How to return the date part only from a SQL Server datetime ...

2008年9月22日 - SELECT GETDATE(). Returns: 2008-09-22 15:24:13.790. I want that ... SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date)). for example

stackoverflow.com