Overview
| Artifact ID: | 6b8e355d943a34507eea564ff7ecdcb2a0075d11 |
|---|---|
| Ticket: | bf4f5725f6c90fc2a113e35acde27e25e6b290b2
Tickets: cannot display in local time |
| User & Date: | anonymous 2010-12-22 10:00:19 |
Changes
- comment changed to:
All the times in the ticket reports and comments are in UTC. Admin/Timeline/Use UTC settings has no effect. I try to convert the time to local in SQL with something like this (syntax suggested by sqlite docs)<br> SELECT datetime(tkt_mtime, 'localtime') AS 'mtime' FROM ticket<br> and get the following error<br> error code 23: access to config.value is prohibited<br> Database Error<br> access to config.value is prohibited<br> SELECT value FROM config WHERE name='timeline-utc'<br> If you have recently updated your fossil executable, you might need to run "fossil all rebuild" to bring the repository schemas up to date<br> Running 'fossil all rebuild' does not help. Is this a bug or am I missing the proper way to convert timestamps to local time?
- foundin changed to: "0018d724b3"
- private_contact changed to: "142de1aaa3c6b6828c4cb71e1c6c3e3202b0352f"
- severity changed to: "Important"
- status changed to: "Open"
- title changed to: "Tickets: cannot display in local time"
- type changed to: "Code_Defect"