sql - 在sql server中将年月日转换为日期

Question

我对存储过程的输入是一个字符串(例如“2 年 3 个月 4 天”)，它是一个 future 日期。如何通过与当前日期比较将其转换为日期？

Answer 1

declare @S varchar(50)
set @S = '2 years 3 months 4 days'

select dateadd(day, D.D, dateadd(month, D.M, dateadd(year, D.Y, getdate()))) as TheDate
from (select replace(replace(replace(@S, ' years ', '.'), ' months ', '.'), ' days', '')) as T(S)
  cross apply (
              select cast(parsename(T.S, 1) as int),
                     cast(parsename(T.S, 2) as int),
                     cast(parsename(T.S, 3) as int)Y
              ) as D(D, M, Y)

SQL Fiddle