select startdttime ,enddttime, startdttime +'~'+enddttime as dttime
from mytable
startdttime +'~'+enddttime as dttime
这个这个拼接的时候回出问题.说是字符型和DT型转换的问题..
请问这个怎么整啊?
from mytable
startdttime +'~'+enddttime as dttime
这个这个拼接的时候回出问题.说是字符型和DT型转换的问题..
请问这个怎么整啊?
enddttime.ToString("yyyy-mm-dd")
from mytable
select startdttime,enddttime,'['+cast(startdttime as varchar(50))+'~'+cast(enddttime as varchar(50))+']' dttime from yourTable