SQL Query to STIRP OFF time part using DateAdd() : Team,
I searched online and don't get proper answers to my need. 
Basically, with below in my query am getting output in Date column as 

WHERE DATE >= DATEADD(MONTH, -3, GETDATE())

Output:
Date: 2017-12-1 00:00:00:00

I don't want to see those 0s at all and just want pure date value present.

my date column should only show me date and nothing for time, not even 0s