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