如何在db2中连接字符串
1、用两条竖线 ||
select char(year(current date))||char(month(current date))||char(day(current date)) as ss from aaa
select char(year(current date))||char(month(current date))||char(day(current date)) as ss from aaa
2、调用CONCAT函数
select char(year(current date)) concat char(month(current date)) concat char(day(current date)) as ss from aaa
select char(year(current date)) concat char(month(current date)) concat char(day(current date)) as ss from aaa
扫一扫
896
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
