Convert Function Example
Code:
Highlight
CREATE PROCEDURE dbo.sp_Get_PressRelease @DateAddedFrom Datetime, @DateAddedTo Datetime AS SELECT @DateAddedTo = Convert(datetime, Convert(char(10), DateAdd(d, 1,@DateAddedTo), 101)) SELECT * FROM PressRelease WHERE DateAdded >= @DateAddedFrom AND DateAdded <= @DateAddedTo ORDER BY DateAdded ASC