목록Database/MSSQL (2)

정보 도우미

mssql date function

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..
Database/MSSQL 2016. 2. 16. 11:54
Prev 1 2 Next