Converting datetime to date

[renee35]

It's Friday and my brain is fried, could someone please tell me what needs to be done to the below formula to have it display a date only:

CONVERT(varchar(10), getdate() - 4, 101)

Thanks a bunch!!

-T

 

[RiverGuy]

Try:

CONVERT(DATETIME, CONVERT(varchar(10), getdate() - 4, 112))

 

[renee35]

Still getting the time.

Thanks a bunch!!

-T

 

[RiverGuy]

You mean you want the time completely gone? To do that in SQL Server <= 2005, you can't use a DATETIME datatype. You're going to have to convert to character data. If you are using Reporting Services, it's much easier to do this on the front end.