Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION changeDate (@INPUT DATE)
- RETURNS DATE
- AS BEGIN
- DECLARE @tempDate DATE = CAST( DATEADD(DAY, -28,(SELECT DATEADD(YEAR, -5,(SELECT DATEADD(MONTH, -3, @INPUT))))) AS DATE)
- RETURN @tempDate
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement