By XeroCube | April 29, 2011
Just to remind myself at a later date, this is a SQL Query that shows how to strip the timestamp from a datetime value.
Declare @fulldate datetime
Set @fulldate = getdate()
Declare @shortdate smalldatetime
Set @shortdate = convert(datetime,convert(char(10),getdate(),101))
Select @fulldate, @shortdate