LAST_DAY function in db2
Posted: Wed Sep 02, 2009 7:07 am
Hi All,
I have this field which needs to get the month end date of a given date field . i am populating a db2 table. I know db2 does have a function LAST_DAY which would give this result, i tried using this function on Advanced Query Tool , but i'm getting the following error
42884(-440)[IBM][CLI Driver][DB2/AIX64] SQL0440N No authorized routine named "LAST_DAY" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884
(0.19 secs)
Do not know as to why i'm getting this error.
any help in achieving this task would be of great help
Thanks in advance
I have this field which needs to get the month end date of a given date field . i am populating a db2 table. I know db2 does have a function LAST_DAY which would give this result, i tried using this function on Advanced Query Tool , but i'm getting the following error
42884(-440)[IBM][CLI Driver][DB2/AIX64] SQL0440N No authorized routine named "LAST_DAY" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884
(0.19 secs)
Do not know as to why i'm getting this error.
any help in achieving this task would be of great help
Thanks in advance