Hi,
I have a table with fields like yr and month of type decimal and smallint respectively. I want to compare the date value formed by the yr and the month values in the tables by taking the day by default as 01. So the date should look like yr-month-01 in DB2. How do I combine these values and form a datre value out of them?
Please reply if you know the solution.
Thanks,
Nidhi.