DB2添加MOD函数旁边的单词

Question

我想添加单词周显示为周然后从函数MOD编号我尝试了以下

select EVENTTIMESTAMP, Year (EVENTTIMESTAMP) as Year, QUARTER (EVENTTIMESTAMP) as Quarter, 'Week' MOD(WEEK(EVENTTIMESTAMP)-1, 13) + 1 as WeekNoQuarter

但是我得到错误:

在" Quarter， 'Week'"后面发现了一个意外的令牌"MOD"。预期的令牌可能包括:"，"..SQLCODE=-104, SQLSTATE=42601, DRIVER=4.16.53

有什么建议吗?

谢谢!

Answer 1

在您的代码中，您试图将字符串'Week'命名为MOD(Week (EVENTTIMESTAMP)- 1,13) + 1作为WeekNoQuarter。尝试将字符串'Week '与计算值连接(||)。由于计算值是int类型，因此必须对其进行强制类型转换:

'Week ' || cast(MOD(WEEK(EVENTTIMESTAMP)-1, 13) + 1 as char(2)) as WeekNoQua...