Advertisement
Guest User

Untitled

a guest
Dec 13th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.22 KB | None | 0 0
  1.  
  2. CREATE FUNCTION changeDate (@INPUT DATE)
  3.     RETURNS DATE
  4.     AS BEGIN
  5.         DECLARE @tempDate DATE = CAST( DATEADD(DAY, -28,(SELECT DATEADD(YEAR, -5,(SELECT DATEADD(MONTH, -3, @INPUT))))) AS DATE)
  6.         RETURN @tempDate
  7.     END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement