在datetime变量中更新年份 [英] Updating year in datetime variable

问题描述

我正在操纵一个 datetime 变量。我似乎找不到一种方式来更新当前年份的 datetime 变量年。

I'm playing around with manipulating a datetime variable. I can't seem to find a way to update a datetime variable year to the current year.

例如我有

2007-12-01 00:00:00.000

但是我想要这样做

2012-12-01 00:00:00.000    (The current year were in)

我一直在玩code> datediff ，但我似乎无法指责。

I've been playing with datediff, but I can't seem to nail it.

任何建议将不胜感激。

谢谢

推荐答案

DECLARE @date datetime = '2007-01-09T12:34:56'
SELECT @date = DATEADD(yyyy, DATEDIFF(yyyy, @date, GETDATE()), @date)

SELECT @date

这篇关于在datetime变量中更新年份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！