How are timezone's handled in 'date-time' field?

Is the date & time displayed in the date-time field the same for users sitting in different timezones? Does it show the date & time set on the server?

Or does the date & time displayed adapt to the users local timezone from their browser?

does the date & time displayed adapt to the users local timezone from their browser?

Yes, we always show the date time in the user’s timezone.

And in the database we always default to UTC or the database’s timezone.

Is there a way to force displaying the same time (& therefore timezone) for all users, irrespective of the user’s timezone?

Airtable & Baserow have this feature.