将单独的月份，年份转换为sql server 2008中的有效日期 [英] formating separate month, year into a valid date in sql server 2008

问题描述

你好专业人士





i在Sql Server中有一个问题，我的表中有单独的年份，月份和日期列有效价值。

i需要添加它们并从所有列中生成有效日期因为我需要在Query之间运行。



所以可以任何人帮助我......？

hello professionals


i have a problem in Sql Server that there is in my table separate columns for year and month and date with valid value.
i need to add them and make a valid date from that all columns becouse i need to run Between Query.

so can any one help me......?

推荐答案

你可以尝试这样的事情......

You can try some thing like this...

Declare @Year varchar ='2013', @Month varchar ='7', @Day varchar ='1'
Select Convert(Date, @Year+'-'+@Month +'-'+ @Day)-- Any Version
SELECT DATEFROMPARTS(2012,7,1)  -- For Sql Server 2012 and Above

DateFromParts-MSDN

转换和转换 < a href =http://technet.microsoft.com/en-us/library/ms187928.aspxtarget =_ blanktitle =New Window>

转换W3Schools

谢谢大家我自己解决了.......



使用此代码..



选择CAST（CAST（@ToYear AS varchar）+' - '+ CAST（@ToMonth AS varchar）+' - '来自T_PayBill的ToDate + CAST（1 AS varchar）AS DATE

thanks guys i solved it myself.......

with this code..

select CAST(CAST(@ToYear AS varchar) + '-' + CAST(@ToMonth AS varchar) + '-' + CAST(1 AS varchar) AS DATE) as ToDate from T_PayBill

这篇关于将单独的月份，年份转换为sql server 2008中的有效日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！