10
Use timestamp with or without Timezone in Postgres?
The web application will be used in different countries, so I will have to deal with different time zones. The system has data entry from several different objects that have the day and time the data entered and was changed in the system. This serves for the supervisor to look and check whether it was done within office hours or outside.
Example
If an object is inserted into the bank at 03:00 AM in Italy, the view of this same object in Brazil should also show 03:00 AM.
To complement the context, the backend is in PHP, Postgres database and on the front we have javascript and jQuery.
How should I keep this date in the bank, with or without timestamp? Why?
Using the example I put in the question, should I use with or without Timezone? It was not clear to me.
– Edson Horacio Junior
I commented at the end if you want the time to be the same regardless of the location use without Timezone.
– Gustavo Fragoso