Skip to content

Instantly share code, notes, and snippets.

@ctfaddict

ctfaddict/figure3 Secret

Created Apr 24, 2014
Embed
What would you like to do?
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