search

digital-wellbeing / pws-data

Code used to process the raw PowerWash Simulator study dataset
Creative Commons Zero v1.0 Universal
4 stars 1 forks source link

Adjust timestamps in database #13

Closed mvuorre closed 1 year ago

mvuorre commented 1 year ago

I am trying to adjust all playfab timestamps in the db. To do this I need to order the table by person and timestamp. However I'm not able to do that because I can't order by a timestamp with time zone. @rpsychologist do you have time to take a look at the following line of code? I think there might be some simple sql one-liner to order appropriately but I haven't been able to google it :(

https://github.com/digital-wellbeing/pws-data/blob/339a01081c94ed9a14c719e8d3578592db5b023c/clean-data.Rmd#L291

mvuorre commented 1 year ago

Fixed in 30ad7b4218862d61009cf73775b297ebb915f75b