View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000473 | CATS.cacert.org | User Interface | public | 2008-01-04 12:16 | 2011-04-20 12:47 |
Reporter | Ted | Assigned To | Ted | ||
Priority | low | Severity | tweak | Reproducibility | always |
Status | needs work | Resolution | open | ||
Summary | 0000473: Timestamp of test is shown in local time without giving the timezone | ||||
Description | ... which irritates users in different timezones. | ||||
Tags | No tags attached. | ||||
|
Columns for timestamps should always be of type TIMESTAMP (http://dev.mysql.com/doc/refman/5.1/en/timestamp.html ), so timestamps are internally stored as GMT. A timezone can be explicitly set for a DB connection with the command "SET time_zone = '+00:00'" (this example sets GMT timezone). |
Date Modified | Username | Field | Change |
---|---|---|---|
2008-01-04 12:16 | Ted | New Issue | |
2008-01-05 15:14 | evaldo | Category | => User Interface |
2008-01-06 00:06 | Ted | Status | new => needs work |
2008-01-06 00:06 | Ted | Assigned To | => MichelleStahl |
2008-02-06 08:55 | Ted | Note Added: 0001005 | |
2011-04-20 12:47 | Ted | Assigned To | MichelleStahl => Ted |