I’d say the timestamp is stored in UTC then the application / business logic needs to understand what the user’s local time zone is and convert it to whatever local time it is based on that user...