첫날 : yyyy-MM-dd 00:00:00 마지막날 : yyyy-MM-dd 23:59:59 DECLARE @FD VARCHAR(50) DECLARE @TD VARCHAR(50) SET @FD = CONVERT(VARCHAR, DATEADD(MM, DATEDIFF(MM,0, GETDATE()) ,0), 121); SET @TD = CONVERT(VARCHAR, DATEADD(SS, -1, DATEADD(MM, DATEDIFF(MM, 0, GETDATE()) + 1 , 0)), 121); PRINT @FD; PRINT @TD;