如何在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