有条SQL语句，关于数值转换的问题，很简单的，请教大家
SELECT cafebarname, Province + City AS area, baojibegindate + '至 '+ baojienddate AS baojidate, createDate
FROM CafeMember

baojibegindate和baojienddate 是datetime类型

怎么做才能正确呢？

[解决办法]
convert(char(19),baojibegindate,120)+ '至 '+convert(char(19),baojienddate,120)
[解决办法]
SELECT cafebarname, Province + City AS area, convert(char(19),baojibegindate,120)+ '至 '+convert(char(19),baojienddate,120) AS baojidate, createDate
FROM CafeMember