DB2 V6 significantly improved IBM's support for built-in scalar functions. Prior to DB2 V6 there were only 22 built. SELECT EMPNO. For example, from the DB2 Command Line Processor. DAYOFWEEK_ISO: Returns the day of. Durga Sahasranama Namavali Pdf more. Db2 connect to DBNAME db2 bind @db2ubind.lst datetime ISO blocking all. The DAYOFWEEK_ISO function returns an integer between 1 and 7 that represents the day of the week, where 1 is Monday and 7 is Sunday. The DAYOFWEEK_ISO function returns an integer, in the range of 1 to 7, that represents the day of the week, where 1 is Monday and 7 is Sunday. The DAYOFWEEK_ISO.

• agulland Post author Hi, yes that certainly does look cleaner! I think I was just adapting the DB2 functions from what I had for SQL Server and so may have just simply missed this trick – doubt if my technique is any better. By extension you could adapt your formula to calculate last day of week and first and last days of next week. Marvel Vs Dc Vs Snk Vs Capcom on this page.

And I guess by using DAYOFMONTH and DAYOFYEAR functions you could do similar logic for first and last days for month and year. Thanks for comment, next time I have access to DB2 I should update article with these!