---

tags:

• database
• mssql

---

Mssql sql functions

Date

select getdate() -- now select dateadd(dd, 100,getdate()) select dateadd(mm, -16,getdate()) select datepart(yyyy, getdate()) select year(getdate()) select month('2022-12-23')