I am trying to get the date difference between a date in a DB2 column and today's date and updating it to a column.
The column type that I am updating it to is character.
I am getting an error, new value has wrong data type when trying this SQL statment.
UPDATE W17G.INVOICE
SET DAYS_N_QUEUE =
DAY(CURRENT DATE - QUEUE_DT);
Does the DAYS_N_QUEUE column need to be a date type?
[sig][/sig]
The column type that I am updating it to is character.
I am getting an error, new value has wrong data type when trying this SQL statment.
UPDATE W17G.INVOICE
SET DAYS_N_QUEUE =
DAY(CURRENT DATE - QUEUE_DT);
Does the DAYS_N_QUEUE column need to be a date type?
[sig][/sig]