정보 도우미

SELECT GETDATE(); --today SELECT CONVERT(CHAR(8), DATEADD(dd,-1,GETDATE()),112); -- yesterday SELECT CONVERT(CHAR(8), DATEADD(dd,+1,GETDATE()),112); --tomorrow SELECT CONVERT(CHAR(8), DATEADD(mm,+3, GETDATE()),112); -- next 3 month SELECT CONVERT(CHAR(8), DATEADD(yy,+1, GETDATE()),112); -- next 1 year SELECT CONVERT(CHAR(8), DATEADD(mm, -1, GETDATE()-DAY(GETDATE()-1)),112); -- before 1 month SEL..