Skip to content

Instantly share code, notes, and snippets.

@jthandy

jthandy/stripe_invoices_cleaned.sql

Created April 6, 2016 15:14
Show Gist options
  • Save jthandy/8ad70f4908f63bd760af0accfa577063 to your computer and use it in GitHub Desktop.
Save jthandy/8ad70f4908f63bd760af0accfa577063 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
stripe_invoices_cleaned.sql
select
customer,
timestamp 'epoch' + date * interval '1 Second' as date,
forgiven,
subscription_id,
paid,
total,
timestamp 'epoch' + period_start * interval '1 Second' as period_start,
timestamp 'epoch' + period_end * interval '1 Second' as period_end
from
stripe_invoices
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment