Business Objects Business Objects - 1 year ago 86
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 Source

On SQL Server 2008 and higher:

SELECT CONVERT(date, getdate())

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download