Unanswered: "Arithmetic overflow or underflow" using db2 function monthname
on DB2 v8.2 fp11 on Linux I have strange problem using db2 function monthname.
Executing bellow SQL returns error:
db2 select monthname('2008-07-01') from sysibm.sysdummy1
---- error message ----
SQL0443N Routine "SYSFUN.MONTHNAME" (specific name "SQL020703081922408") has
returned an error SQLSTATE with diagnostic text "SYSFUN:03". SQLSTATE=38552
I looked at detailed explanation of error for "SYSFUN:03" and got info:
03 Arithmetic overflow or underflow
By the way I have also tried bellow and getting the same error:
db2 select monthname(date('2008-07-01')) from sysibm.sysdummy1 and
This is very strange, because this SQL is in production environment and it was working fine for few months now.
I know system administrator has changed system time on computer. Can this effect? Is this a bug in DB2?
I saw that thread too. But I know that was not a proper solution. There's got to be some kind of bug in v8. This problem appears time to time - if I don't mistaken if some sysadm changes system time.