sql - MS-SQL Server / »ù´¡Àà

ÎÒÏëÔÚÒ»¸öÈÕÆÚµÄÔ·ÝÉÏ ¼Ó 1 ÈçºÎʵÏÖ£¿

»òÕß ÔÚÄê·ÝÉϼÓ1

---

dateadd(mm,1,dt)
dateadd(yy,1,dt)

---

ok¡¡¡¡£³£ñ

---

ÒýÓÃ

SQL code
select dateadd(mm,1,getdate())
select dateadd(yy,1,getdate())

/*

------------------------------------------------------
2010-0¡­¡­

Õâô¿ì¾Í½áÊøÁË

---

dateadd(month,1,'2010-01-23')

---

SQL code:

select dateadd(mm,1,'2010-01-01')
select dateadd(yy,1,'2010-01-01')
/*
------------------------------------------------------
2010-02-01 00:00:00.000

£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©


------------------------------------------------------
2011-01-01 00:00:00.000

£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©

*/