concatenate columns 1

[richey1]

I have two columns - Decisionday of datatype numeric and decisionmonth of dattype datetime
How can i concatenate these two columns?

so if decisionmonth says 01/01/05 and decisionday is 23 then Expr1 would be 23/01/05

thanks
ian

 

[derren]

I am just passing through, so as a quickie, try:

cast(cast(decisionmonth as varchar(4)) + cast(Decisionday as varchar(2)) + substring(cast(decisionmonth as varchar(20)),7,20) as datetime)

Derren
[Mediocre talent - spread really thin]

 

[vongrunt]

One of many ways:

dateadd( dd, DecisionDay-datepart(dd, DecisionMonth), DecisionMonth )

 

[derren]

Oh, that's much better

Derren
[Mediocre talent - spread really thin]