Hi all,
just a small issue and I believe it's just ery simple for you.
select to_char(systimestamp- INTERVAL '120:00' MINUTE TO SECOND, 'Dy DD-Mon-YYYY HH24:MI:SS') from dual;
works very fine...
But I want to replace the '120:00' with a variable 'v_interval' so that the interval is not fix.
But on every try I end's into 'invalid interval'..
Please help me.
Thanks
Joerg