Just wanted to give this tip as I could not find help online....
If you are struck in a situation to add a variable to a timestamp column, you have to cast that variable to that particular interval day or minute or second.
DECLARE v_DAY_INT INTEGER;
SELECT CURRENT_TIEMSTAMP(3)+INTERVAL :v_DAY_INT DAY ; does not work.
SELECT CURRENT_TIEMSTAMP(3)+CAST(:v_DAY_INT AS INTERVAL DAY) will work.
Also, you should know that you cannot cast a timestamp to a date column and then add a day.
Hopefully this helps someone.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.