Advertisement
elena1234

DATEADD() in T-SQL

Dec 28th, 2021 (edited)
4,931
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.14 KB | None | 0 0
  1. USE Orders
  2. SELECT ProductName, OrderDate, DATEADD(DAY, 3, OrderDate) AS [Pay Due], DATEADD(MONTH, 1, OrderDate) AS [Deliver Due]
  3. FROM Orders
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement