Skip to content

Instantly share code, notes, and snippets.

View timlenardo's full-sized avatar

Tim L timlenardo

View GitHub Profile
@reallabs
reallabs / .sql
Created April 17, 2018 21:46
Goal Charts in SQL
WITH dates as (
SELECT ds, row_number() OVER () as rnum
FROM generate_series(
date_trunc('month', now())::timestamp AT TIME ZONE 'PST',
date_trunc('month', now() + INTERVAL '1 month')::timestamp AT TIME ZONE 'PST',
'24 hours')
as ds
)
SELECT ds, goal,
.get('/apple-app-site-association', function(req, res) {
res.header('Content-Type', 'application/pkcs7-mime');
res.render('apple-app-site-association.txt');
})