Skip to content

Instantly share code, notes, and snippets.

@indy-singh

indy-singh/cron.sql

Created November 2, 2024 23:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save indy-singh/6ea8041ea0999a2c98210e7f794e728f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save indy-singh/6ea8041ea0999a2c98210e7f794e728f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cron.sql
SELECT t_minute || ' ' || t_hour || ' ' || t_day_of_month || ' ' || t_month || ' ' || t_day_of_week
FROM generate_series(0,59) t_minute
, generate_series(0,23) t_hour
, generate_series(1,31) t_day_of_month
, generate_series(1,12) t_month
, generate_series(0,6) t_day_of_week;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment