Notice
Recent Posts
Recent Comments
목록날짜함수 (1)
분노의 챔질
반응형
declare @StartDate datetime = '2010-01-25', @EndDate datetime = '2010-02-05' select GETDATE() select dateadd(day, 10, @StartDate), dateadd(day, -10, @StartDate) select datediff(day, @StartDate, @EndDate), datediff(month, @StartDate, @EndDate) select datepart(year,@StartDate), datepart(month,@StartDate) ,datepart(day,@StartDate) select year(@StartDate), month(@StartDate), day(@StartDate) GETDATE(..
Programming/SQL
2010. 3. 23. 11:19
반응형