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’s setting. It’s not really a Nostr thing, though, an application thing