Skip to content

Instantly share code, notes, and snippets.

@mattm

mattm/comma-first.sql Secret

Created Nov 12, 2018
Embed
What would you like to do?
Comma First vs Last
# 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