sql - Return date, hours,minutes and seconds included from function

Question

My functions looks as below, but it does not work. I can't really figure out what. Tried to return "sysdate" as well, help would be much appreciated.

I want it to display hours, minutes and seconds, not just a date!

create or replace function get_date
return date
is 
begin
return sysdate('YYYY-MM-DD: HH24:MI:SS') + 7;
end;
/

Answer 1

You just want:

return sysdate + 7

if you want to add 7 days to the current date.