Skip to content

Instantly share code, notes, and snippets.

@mattm

mattm/comma-first.sql Secret

Created November 12, 2018 17:25
Show Gist options
  • Save mattm/a5359354e669c2a426f7775381ff3efd to your computer and use it in GitHub Desktop.
Save mattm/a5359354e669c2a426f7775381ff3efd to your computer and use it in GitHub Desktop.
Download ZIP
Comma First vs Last
Raw
comma-first.sql
# Good: Comma last
...
SELECT
email,
FROM_UNIXTIME(property_beacon_interest/1000) as expressed_interest_at
FROM
hubspot.contact
...
# Good: Comma first
...
select
email
,dateadd(s, convert(int,left(property_beacon_interest,10)), '1970-01-01')
from hubspot.contact
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment