I'm trying to extract the day portion of an TO_DSINTERVAL data type using
extract (DAY FROM :ELAPSED_TIME), elapsed_time is the name of the field, I'm working in report builder. Below is what I've put in a function to extract the day:
function Elapsed_DaysFormula return NUMBER is
CURSOR days_cursor IS
SELECT extract(day from elapsed_time)
FOR days_row IN days_cursor
days_elapsed := days_row.elapsed_time;
getting the error component elapsed_time must be declared.