I hereby claim:
- I am areohbe on github.
- I am areohbe (https://keybase.io/areohbe) on keybase.
- I have a public key ASDU2EiSBFB9TiOGKnjUsgXj1H6y0AHVPaliwZ6pZbgEygo
To claim this, I am signing this object:
--Case statement covnert user generated events to the user's local time zone based on a user's state | |
--Best used when your date/time field is stored as a timestampz, time zone aware, value in postgres | |
--For states that have more than one time, the time zone with the largest population is used. | |
--Exmaple use case: figuring out what percentage of user generated events take place outside of buiness hours | |
--Replace 'state' and 'event_time' with the respective columns names from your postgres database. | |
case | |
when state in ('CT','DE','DC','FL','GA','IN','KY','ME','MD','MA','MI','NH','NJ','NY','NC','ND','OH','PA','RI','SC','VT','VA','WV') then event_time at time zone 'us/eastern' | |
when state in ('AR','IL','IA','KS','LA','MN','MS','MO','MT','NE','OK','SD','TN','TX','WI') then event_time at time zone 'us/central' |
I hereby claim:
To claim this, I am signing this object:
cleanup -n
const fetchMachine = Machine({ | |
id: "powerUp", | |
initial: "inactive", | |
context: { | |
count: 0, | |
selected: { | |
sender: undefined, | |
filter: undefined | |
}, | |
filters: undefined, |