SQL operations on time, such as increasing the reduction of one day in the current time, and increasing the reduction by one months in the current time

Select GETDATE ()
Select CONVERT (varchar), DATEADD (Month,-1,getdate ()), 120)

Select CONVERT (varchar), DATEADD (Dd,1,getdate ()), 120)

The results are as follows:

Disclaimer: The above text is "Wuhan Han Code Technology Co., Ltd." original, reproduced when must be marked the source.

Technology sharing, communication between you and me, common progress! Www.hanma-scan.com

SQL operations on time, such as increasing the reduction of one day in the current time, and increasing the reduction by one months in the current time