일단모아/마구마구
Sql Date 함수 변환
반생자
2009. 3. 23. 11:22
SELECT CONVERT(NVARCHAR, DATEADD(M,-1,'20090301'), 110)
> 02-01-2009
SELECT CONVERT(NVARCHAR, DATEADD(M,-1,'20090301'), 111)
> 2009/02/01
SELECT CONVERT(NVARCHAR, DATEADD(M,-1,'20090301'), 112)
> 20090201
SELECT CONVERT(NVARCHAR, DATEADD(M,-1,'20090301'), 113)
> 01 02 2009 00:00:00:000
SELECT CONVERT(NVARCHAR, DATEADD(M,-1,'20090301'), 114)
> 00:00:00:000