How to remove time from date time. 1

[bloko]

I need to group by date but the format of the date is date time so is coming out like

23/01/2009 14:05:52

I need to get rid of the time, what function can I use to delete the last 10 character?

 

[bborissov]

SELECT DATEADD(dd,0,DATEDIFF(dd,0,GETDATE()))

Of course instead of GETDATE() you should use your fields from the table.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[bloko]

Fantastic, just what I was after. Thanks a lot