I am building a system that will track events and tasks. I would like
to store the data for each event in a table, so that the trigger can
look up events in the table that meet certain criteria and then insert
records in the task/event table with the appropriate event status,
date, etc.
My problem is that with each event I would like to store a date that
is either sysdate or sysdate plus some number of days. Right now I am
storing this date as 'sysdate' or 'sysdate + 60' in a varchar2 field.
But the trigger is not happy when it tries to insert this into the
task table, where the date is formatted as a date.
Can anyone tell me how to get the trigger to recognize 'sysdate' as a
true sysdate?
Thank you,
Sidney