12 Replies Latest reply: May 2, 2013 9:38 AM by 1002942 RSS

    can someone kindly assisst me witht his simple function :)

    1002942
      Create a function get_return_date. It is intended to be stored in a variable that is printed on a lease.

      Example: One person goes into a hire firm and rents an item in, say 7 days. If it is the 4th of October at 23:59, the function returns: date + hour + minutes,


      SELECT get_return_date(7)
      FROM dual;


      GET_RETURN_DATE(7)
      ----------------------------
      2004-10-11:23