Tag Archives: values

first and last day of the month

Here is a quick way to find the first and last day of the month : with temp1 (first_day_of_month,last_day_of_month) as (values ((current date – day(current date + 1 month) days) + 1 DAY,  (current date + 1 month) – day(current … Continue reading

Posted in db2 | Tagged , , , , | Leave a comment