Skip to content

Instantly share code, notes, and snippets.

@sofakingworld

sofakingworld/hours.sql

Created June 9, 2019 00:15
Show Gist options
  • Save sofakingworld/e6cd25644442f68ae5e360b927ad138b to your computer and use it in GitHub Desktop.
Save sofakingworld/e6cd25644442f68ae5e360b927ad138b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hours.sql
;WITH hours as (
SELECT 0 hour_id, '00:00 - 01:00' hour_literal UNION
SELECT 1 hour_id, '01:00 - 02:00' hour_literal UNION
SELECT 2 hour_id, '02:00 - 03:00' hour_literal UNION
SELECT 3 hour_id, '03:00 - 04:00' hour_literal UNION
SELECT 4 hour_id, '04:00 - 05:00' hour_literal UNION
SELECT 5 hour_id, '05:00 - 06:00' hour_literal UNION
SELECT 6 hour_id, '06:00 - 07:00' hour_literal UNION
SELECT 7 hour_id, '07:00 - 08:00' hour_literal UNION
SELECT 8 hour_id, '08:00 - 09:00' hour_literal UNION
SELECT 9 hour_id, '09:00 - 10:00' hour_literal UNION
SELECT 10 hour_id, '10:00 - 11:00' hour_literal UNION
SELECT 11 hour_id, '11:00 - 12:00' hour_literal UNION
SELECT 12 hour_id, '12:00 - 13:00' hour_literal UNION
SELECT 13 hour_id, '13:00 - 14:00' hour_literal UNION
SELECT 14 hour_id, '14:00 - 15:00' hour_literal UNION
SELECT 15 hour_id, '15:00 - 16:00' hour_literal UNION
SELECT 16 hour_id, '16:00 - 17:00' hour_literal UNION
SELECT 17 hour_id, '17:00 - 18:00' hour_literal UNION
SELECT 18 hour_id, '18:00 - 19:00' hour_literal UNION
SELECT 19 hour_id, '19:00 - 20:00' hour_literal UNION
SELECT 20 hour_id, '20:00 - 21:00' hour_literal UNION
SELECT 21 hour_id, '21:00 - 22:00' hour_literal UNION
SELECT 22 hour_id, '22:00 - 23:00' hour_literal UNION
SELECT 23 hour_id, '23:00 - 00:00' hour_literal
ORDER BY 1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment