Skip to content

Instantly share code, notes, and snippets.

@ctfaddict
Created April 24, 2014 05:35
Show Gist options
  • Save ctfaddict/cc38cb3240c1f43fe65b to your computer and use it in GitHub Desktop.
Save ctfaddict/cc38cb3240c1f43fe65b to your computer and use it in GitHub Desktop.
scorebot_production=# select s.name, date_trunc('minute', i.created_at) as created
from instances i, services s
where i.service_id = s.id
group by s.name, created
order by created asc;
name | created
----------+---------------------
atmail | 2013-08-02 16:05:00
bookworm | 2013-08-02 16:05:00
lonetuna | 2013-08-02 16:05:00
reeses | 2013-08-03 01:44:00
avoir | 2013-08-03 18:34:00
trouver | 2013-08-03 18:34:00
(6 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment