sqlite3_extensions

collection of sqlite3 extensions

cron.c

• cron_match(date text, cron_entry text) allows you to compare dates against cron entries, whether they match or not
• f.e.:
  • select cron_match('2000-01-01 00:03:00', '*/3 * * * *'); returns 1
  • select date from test1 where cron_match(date, '*/9 */10 * * *'); returns

    date
    2000-01-04 10:27:00
    2000-01-04 10:36:00
    2000-01-04 10:45:00
    2000-01-04 10:54:00
    2000-01-04 20:00:00
    2000-01-04 20:09:00
    2000-01-04 20:18:00
    2000-01-04 20:27:00
    2000-01-04 20:36:00
    2000-01-04 20:45:00
    2000-01-04 20:54:00
    2000-01-05 00:00:00
    2000-01-05 00:09:00
    2000-01-05 00:18:00
    2000-01-05 00:27:00
    2000-01-05 00:36:00
    2000-01-05 00:45:00
    2000-01-05 00:54:00
    2000-01-05 10:00:00
    2000-01-05 10:09:00
    2000-01-05 10:18:00
    2000-01-05 10:27:00
    2000-01-05 10:36:00