Well, yeah, you’re right. I totally lost track of what you were actually asking.
Sorry about that.
you will need to compare the time value to the time now and if they are equal then make the trigger return “true”.
Ok, I’ve tried to manipulate this every way I know to do and I can’t seem to get any comparison to return a true for the trigger.
Unless someone else has any ideas I think the best (and only way I know) to do this is to change your input_datetime to contain the date and then just use the trigger template I gave in the beginning.
I think it has to do with the native data type changes in the latest versions but I can’t even e sure of that.