View Issue Details

IDProjectCategoryView StatusLast Update
0000473CATS.cacert.orgUser Interfacepublic2011-04-20 12:47
ReporterTed Assigned ToTed  
Status needs workResolutionopen 
Summary0000473: Timestamp of test is shown in local time without giving the timezone
Description... which irritates users in different timezones.
TagsNo tags attached.



2008-02-06 08:55

administrator   ~0001005

Columns for timestamps should always be of type TIMESTAMP ( ), 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).

Issue History

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