Skip to Content
avatar image
Former Member

Adding Minutes to Date time stamp object in deski report

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 17, 2008 at 05:35 AM

    Hi ,

    To add

    10 Minutes from Now SYSDATE + 10/1440

    Select sysdate,sysdate+10/1440 from Dual;

    Regards

    Prashant

    Add comment
    10|10000 characters needed characters exceeded