Skip to content

Instantly share code, notes, and snippets.

@aishfenton
Created November 17, 2013 00:59
Show Gist options
  • Save aishfenton/7507577 to your computer and use it in GitHub Desktop.
Save aishfenton/7507577 to your computer and use it in GitHub Desktop.
select regexp_extract(date_time,'[^T]*T([0-9][0-9])', 1), count(*)
from single_search
group by regexp_extract(date_time,'[^T]*T([0-9][0-9])', 1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment