SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

interval on systimestamp as variable

611050Jun 25 2009 — edited Jun 29 2009

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

This post has been answered by Solomon Yakobson on Jun 25 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2009

Added on Jun 25 2009

5 comments

3,336 views