PL/SQL function to add +7 days to SYSDATE
<p>We're supposed to make a function that adds +7 days to the current <code>SYSDATE</code>, and also write the time and minute, however, my code only displays the date, not the time. What am I doing wrong? This is probably very easy, but I just can't figure it out, and there's not much help on the Internet either.</p>

<p>So far, I've tried:</p>

<pre><code>CREATE OR REPLACE FUNCTION get_date(n IN NUMBER) 
RETURN DATE AS
BEGIN
  RETURN to_date(to_char(SYSDATE, 'DD.MM.YYYY HH24:MI'),'DD.MM.YYYY HH24:MI') + n;
END get_date;
/
</code></pre>

<p>So when you write (the 7 is the amount of days to advance):</p>

<pre><code>SELECT get_date(7)
FROM dual;
</code></pre>

<p>Its result is this:</p>

<pre><code>GET_DATE(7)
----------------
09.03.2016 
</code></pre>

<p>However, as you can see, the time isn't included in the result, and that's what I need in this case. Any help at all would be appreciated. I'm sure I'm just too blind to see it, but I've stared for too long on this piece of code now, I'll admit my defeat.</p>