APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculating Time by adding Mins

MarieSep 28 2009 — edited Sep 28 2009

Hi All,

I haven been working to calculate the time when I have a specific time and the duration of time in minutes.

So far I have come up with

Example of v_appointment_duration = 30 (mins) is always in minutes

v_end_time := to_date(trunc(i_start_date,'HH:MI') + (v_appointment_duration/(60*24)));

I keep receiving the below error and cant figure out why:

ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 26 2009

Added on Sep 28 2009

#apex-discussions

6 comments

291 views