Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Syntax

CRON_MATCHER(<pattern>;<date>)

Note

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

...