Get Only Date from Datetime in Sql
Sometimes we need to have only date from datetime field in sql.
There are number of ways to accomplish that:
Suppose we take current date
now to take only date from current date excluding time, we do as follows in various ways:
select DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
select cast(cast(getdate() as int) as datetime)
select cast(convert(varchar,getdate(),110) as datetime)