Business Objects Business Objects - 5 months ago 45
SQL Question

Datetime need the date only

I have a column in SQL Server that is datetime this is a typical value

10/6/2016 8:40:00PM

I want to process just according to the date.

I want to group a report by date only. What must I do for this?


On SQL Server 2008 and higher:

SELECT CONVERT(date, getdate())