I just used this for the 1000th time so I thought i would blog about it. Just replace getdate() and with your date...
-- just the date
SELECT CONVERT(char(10), getdate(), 101) AS [Date]
SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
-- just the time
SELECT (getdate() -
CAST(ROUND(CAST(getdate() AS float), 0, 1) AS datetime))
SELECT CONVERT (datetime, (1 - (CONVERT (float, getdate() ) -
CONVERT (int, CONVERT (float, getdate())))) * - 1 - 1)