ziangij (8/31/2010)

---

DECLARE @a INT
DECLARE @b DATETIME

SET @b = @a

implicit conversion from int to datetime works fine

mbova407 (9/1/2010)

---

This is how we get the date for the current day without time element

DECLARE @a INT
DECLARE @b DATETIME
set @b = GETDATE()-.5
SET @a = CONVERT(INT,@b)
SELECT CONVERT(DATETIME, @a), @b

the -.5 is half a day because CONVERT(INT,@b) rounds

Select CONVERT(varChar(10), getDate(), 101);