formating separate month, year into a valid date in sql server 2008

Question

0.00/5 (No votes)

See more:

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......?

Posted 13-Sep-13 17:53pm

Shubh Agrahari

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raja Sekhar S · Accepted Answer · 2013-09-13T18:50:00

Solution 1

You can try some thing like this...

SQL

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
Cast And Convert
Convert W3Schools

Posted 13-Sep-13 18:50pm

Raja Sekhar S

Updated 13-Sep-13 18:54pm

v2

Comments

Shubh Agrahari 14-Sep-13 1:41am

thanks friend but i done this..........by this
select CAST(CAST(@ToYear AS varchar) + '-' + CAST(@ToMonth AS varchar) + '-' + CAST(1 AS varchar) AS DATE) as ToDate from T_PayBill

Raja Sekhar S 14-Sep-13 2:38am

You are welcome...

Shubh Agrahari · Accepted Answer · 2013-09-13T19:42:00

Solution 2

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

Posted 13-Sep-13 19:42pm

Shubh Agrahari

formating separate month, year into a valid date in sql server 2008

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

formating separate month, year into a valid date in sql server 2008

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us