Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2009
Added on Jun 25 2009
5 comments
3,336 views