SQL Serverで日付を加算

備忘録

update
	data
set
	Time = (
		SELECT
			FORMAT( DATEADD(month, 6, t2.Time), 'yyyy/MM/dd HH:mm:ss.fff')
		FROM
			data t2
		WHERE
			t2.Time = data.Time
	),
	TimeStr = (
		SELECT
			FORMAT( DATEADD(month, 6,CONVERT(datetime , stuff(stuff(stuff(stuff(data.TimeStr, 9, 0, ' '), 12, 0, ':'), 15, 0, ':'), 18, 0, '.'))), 'yyyyMMddHHmmssfff')
		FROM
			data t2
		WHERE
			t2.Time = data.Time
	)