|
ACS3 Data Model |
||||||||||||
|
Name | Data Type | Default Value | In/Out |
---|---|---|---|
START_DATE | DATE | IN | |
END_DATE | DATE | IN |
Source |
---|
1: function poll_is_active_p (start_date in date, 2: end_date in date) 3: return char 4: as 5: result char; 6: begin 7: result := 't'; 8: 9: if (trunc(start_date) > trunc(sysdate)) then 10: result := 'f'; 11: end if; 12: 13: if (trunc(end_date) < trunc(sysdate)) then 14: result := 'f'; 15: end if; 16: 17: return result; 18: 19: end poll_is_active_p; 20: |