Adding Minutes to Date time stamp object in deski report

[Former Member]

Hi

Need help on this

I need to add minutes to a datetime stamp object in deski report. Tried using Substr() functions but getting minutes added which exceeds 59 minutes, but when I add 30 minutes to 31 Oct 2008 23:45 then it should be 1 Nov 2008 00:15.

Thanks,

[former_member212749 · Accepted solution]

Hi ,

To add

10 Minutes from Now SYSDATE + 10/1440

Select sysdate,sysdate+10/1440 from Dual;

Regards

Prashant

[Former Member · Accepted solution]

Hi,

But this works in the universe level but I am looking for the report level.

Regards,

Rohit