Add timezone support for scan execution policies

What does this MR do and why?

This MR contains backend changes required for Add timezone context for scheduled pipeline action (#398259 - closed)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.

Related to #398259 (closed)