MSSQL, 줄리안데이트 <-> DATETIME 바꾸는 함수
DATETIME -> 줄리안데이트 CREATE function [dbo].[DATETIME_TO_JULIAN](@date as datetime) returns int as begin -- DataTime 값을 줄리안데이트 형식으로 변환 declare @return as int, @tempdate as char(8), @basedate as datetime, @tempyyyy as int, @interval as int set @tempdate = convert(char(8), @date, 112) set @tempyyyy = year(@date) -- cast(left(@tempdate, 4) as int) set @basedate = convert(datetime, left(@tempdate, 4) +..
2012. 1. 2.
MSSQL, 줄리안 데이트로 바꾸기
이달말일 SELECT ( DatePART ( yy, ( DATEADD(day, -1, DATEADD ( mm, 1, DATEADD(mm, DATEDIFF(mm, 0, getdate()), 0)) ) ) ) -1900 ) * 1000 + DatePART ( dy, ( DATEADD ( day, -1, DATEADD(mm, 1, DATEADD (mm, DATEDIFF(mm, 0, getdate()), 0) ) ) ) ) 전달말일 SELECT ( DatePART ( yy, ( DATEADD(day, -1, DATEADD ( mm, 0, DATEADD(mm, DATEDIFF(mm, 0, getdate()), 0)) ) ) ) - 1900 ) * 1000 + DatePART ( dy, ( DATEADD ( day..
2012. 1. 2.