I created three columns L id, created_at and updated_at.
As you can see, I put the same value for each timezone. But created_at is timezone aware.
On the web application, only the timezone aware will be displayed in the user timezone.
Hope it helps 