CRON_MATCHER

Syntax

CRON_MATCHER(<pattern>;<date>)

The pattern can't be referenced from an existing column.

Description

Checks if the given date matches the given cron expression.

Examples

PatternDateCRON_MATCHER() returns

* * * * *

01/10/2012 10:10

true

10 10 * * *

01/10/2012 10:10

true

10 11 * * *

01/10/2012 10:10

false