본문 바로가기

juliandate -> datetime1

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.

티스토리툴바