DECLARE @tDate DATETIMESET @tDate = GETDATE()SELECT @tDate AS 'Input Date', DATEADD(q, DATEDIFF(q, 0, @tDate ), 0) AS 'frmDate', DATEADD(d, -1, DATEADD(q, DATEDIFF(q, 0, @tDate ) + 1, 0)) AS 'toDate'
No comments:
Post a Comment