PL/SQL-code: Create a function get_return_date.

Question

A person rents a car today and for 7 days. The function will return: date + hours + minutes. Thanks in advance! : )

create or replace function get_return_date(
p_days in number)
return varchar2
is 
begin
return to_char(sysdate,'YYYY-MM-DD:HH24:MI') + p_days;
end;
/

Is there some specific reason you are returning string instead of a date? — Goran Stefanović
– Goran Stefanović, Commented Oct 13, 2017 at 14:55
I tried with to_date and then I did get the date back, not the time. — Skorpan
– Skorpan, Commented Oct 13, 2017 at 16:50

Gordon Linoff · Accepted Answer · 2017-10-13 13:13:43Z

1

Add the days before converting to a string:

create or replace function get_return_date(
p_days in number)
return varchar2
is 
begin
    return to_char(sysdate + p_days,'YYYY-MM-DD:HH24:MI');
end;
/

answered Oct 13, 2017 at 13:13

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Skorpan Over a year ago

Thanks a lot : ): ): )

SandPiper · Accepted Answer · 2017-10-13 14:26:49Z

0

The reason your code is not working is because you need to do the math before you convert to a string. Essentially, this is what you are telling the compiler:

"Monday" + 2

That doesn't make any sense in math terms, so it throws an error. the sysdate is actually already a number, so you can add another number to it. Then, you use your to_char to convert that single value into a formatted string like this:

create or replace function get_return_date(
p_days in number)
return varchar2
is 
begin
return to_char(sysdate + p_days,'YYYY-MM-DD:HH24:MI');
end;
/

answered Oct 13, 2017 at 14:26

SandPiper

2,9145 gold badges38 silver badges59 bronze badges

2 Comments

Skorpan Over a year ago

Thanks a lot, it make sense to me now! : ) : )

SandPiper Over a year ago

No problem. If one of these answers solved your problem, please mark it as accepted to indicate to other users your issue was resolved.

Collectives™ on Stack Overflow

PL/SQL-code: Create a function get_return_date.

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related