My first idea was the pipeline when i read the topic. But I’m not a pro, so it can be some other way too.
Try it out. At pipelines a lot of date convert/parse functions what you can use this case.
And maybe another level to use csv lookup table to handle the special days (like national holidays, xmas, etc)
rule "Between 0 and 6 o'clock"
when
to_date($message.timestamp).hourOfDay >= 0 &&
to_date($message.timestamp).hourOfDay <= 6
then
set_field("trigger_alert", true);
end