I have users in multiple time zones. I need to add the ability to pull out data for a view based on when that user last used the app and what’s been added or changed since then.
My question is, should I be using UTCNOW() for the columns I am using for these calculations so the time is consistent across all users? It seems like if I used NOW() there would be inconsistencies.
See: UTCNOW() - What can we do with this?
LinkedIn
Twitter
