Relative Content

Tag Archive for time

How should I deal with Time Zones in a .NET WCF application?

Our company runs a SaaS application where users log in from across the world (although mostly in the US). We store all our time relevant information as UTC, but we need to display times using local time. The application is web based, and we would like to “auto-detect” the user’s Time Zone by using javascript to determine their UTC offsets during various times of the year. The user’s offset info would be passed to our server in their first request and the server will look up all the Time Zones that it knows about and see which valid time zones match.

Is there a constant for “end of time”?

For some systems, the time value 9999-12-31 is used as the “end of time” as the end of the time that the computer can calculate. But what if it changes? Wouldn’t it be better to define this time as a builtin variable?

How is time calculation performed by a computer?

I need to add a certain feature to a module in a given project regarding time calculation. For this specific case I’m using Java and reading through the documentation of the Date class I found out the time is calculated in milliseconds starting from January 1, 1970, 00:00:00 GMT. I think it’s safe to assume there is a similar “starting date” in other languages so I guess the specific implementation in Java doesn’t matter.

How to make a legacy system time-zone sensitive?

I need to implement time zones in a very large and old Delphi system, where there’s a central SQL Server database and possibly hundreds of client installations around the world in different time zones. The application already interacts with the database by only using the date/time of the database server. So, all the time stamps saved in both the database and on the client machines are the date/time of the database server when it happened, never the time of the client machine.

How to handle timezone for dates?

With a YYYY-MM-DD HH:MM:SS date I always store the UTC time. When I pull to display I translate timezones with built-in PHP functions and classes.

(Dis)advantages of datetime vs. long in globally used applications [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for […]