Artifact 6b8e355d943a34507eea564ff7ecdcb2a0075d11:

Ticket change [6b8e355d94] - New ticket [bf4f5725f6] Tickets: cannot display in local time. by anonymous 2010-12-22 10:00:19.

---

D 2010-12-22T10:00:19
J comment All\sthe\stimes\sin\sthe\sticket\sreports\sand\scomments\sare\sin\sUTC.\sAdmin/Timeline/Use\sUTC\ssettings\shas\sno\seffect.\sI\stry\sto\sconvert\sthe\stime\sto\slocal\sin\sSQL\swith\ssomething\slike\sthis\s(syntax\ssuggested\sby\ssqlite\sdocs)<br>\r\nSELECT\sdatetime(tkt_mtime,\s'localtime')\sAS\s'mtime'\sFROM\sticket<br>\r\nand\sget\sthe\sfollowing\serror<br>\r\nerror\scode\s23:\saccess\sto\sconfig.value\sis\sprohibited<br>\r\nDatabase\sError<br>\r\naccess\sto\sconfig.value\sis\sprohibited<br>\r\nSELECT\svalue\sFROM\sconfig\sWHERE\sname='timeline-utc'<br>\r\nIf\syou\shave\srecently\supdated\syour\sfossil\sexecutable,\syou\smight\sneed\sto\srun\s"fossil\sall\srebuild"\sto\sbring\sthe\srepository\sschemas\sup\sto\sdate<br>\r\nRunning\s'fossil\sall\srebuild'\sdoes\snot\shelp.\sIs\sthis\sa\sbug\sor\sam\sI\smissing\sthe\sproper\sway\sto\sconvert\stimestamps\sto\slocal\stime?
J foundin 0018d724b3
J private_contact 142de1aaa3c6b6828c4cb71e1c6c3e3202b0352f
J severity Important
J status Open
J title Tickets:\scannot\sdisplay\sin\slocal\stime
J type Code_Defect
K bf4f5725f6c90fc2a113e35acde27e25e6b290b2
U anonymous
Z beea5b012a6369dca0d07f76aebfb0ca