Skip to main content

Questions tagged [time-zone]

The tag has no usage guidance.

0 votes
1 answer
372 views

Clarification on using timestamp without time zone and LocalDateTime in UTC-centric systems

I'm seeking clarification regarding the usage of timestamp without time zone in a database and its corresponding Java type, LocalDateTime. The current setup I'm working on involves servers and (...
user avatar
0 votes
2 answers
1k views

Best way to match timezone with time offset?

I have a c# solution which uses mssql database to store data. In my database there is a big table of entities (e.g. accounts) for each of which the TimezoneId field is defined. This field is filled ...
Andrey Dengin's user avatar
1 vote
3 answers
463 views

How should I deal with ambiguous local time?

I have a database which stores timestamp, and a UI frontend which contains a date/time field and a time zone field, where the user is supposed to enter the local time into the UI for convenience. ...
Michael Tsang's user avatar