a2005147 发表于 2016-11-16 06:07:40

如何在db2中连接字符串

  如何在db2中连接字符串
  
1、用两条竖线 ||
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
页: [1]
查看完整版本: 如何在db2中连接字符串