Business Objects Business Objects - 1 month ago 8
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?

Answer

On SQL Server 2008 and higher:

SELECT CONVERT(date, getdate())

Comments