Fossil SCM
Change all datetime() calls in tktsetup.c to use toLocal() as their second argument so that they display in the configured timezone. This should resolve [forum:82ac9af1533f78f7 | forum thread 82ac9af1533f78f7].
Commit
2a39681ad16f6f5984914994d41b10a7449d28f5220a0158de9d124ea5be8c7a
Parent
0d94d71d2546551…
1 file changed
+4
-4
+4
-4
| --- src/tktsetup.c | ||
| +++ src/tktsetup.c | ||
| @@ -603,11 +603,11 @@ | ||
| 603 | 603 | @ } |
| 604 | 604 | @ } |
| 605 | 605 | @ } |
| 606 | 606 | @ set seenRow 0 |
| 607 | 607 | @ set alwaysPlaintext [info exists plaintext] |
| 608 | -@ query {SELECT datetime(tkt_mtime) AS xdate, login AS xlogin, | |
| 608 | +@ query {SELECT datetime(tkt_mtime,toLocal()) AS xdate, login AS xlogin, | |
| 609 | 609 | @ mimetype as xmimetype, icomment AS xcomment, |
| 610 | 610 | @ username AS xusername |
| 611 | 611 | @ FROM ticketchng |
| 612 | 612 | @ WHERE tkt_id=$tkt_id AND length(icomment)>0} { |
| 613 | 613 | @ if {$seenRow} { |
| @@ -789,11 +789,11 @@ | ||
| 789 | 789 | @ </tr> |
| 790 | 790 | @ |
| 791 | 791 | @ <th1> |
| 792 | 792 | @ set seenRow 0 |
| 793 | 793 | @ set alwaysPlaintext [info exists plaintext] |
| 794 | -@ query {SELECT datetime(tkt_mtime) AS xdate, login AS xlogin, | |
| 794 | +@ query {SELECT datetime(tkt_mtime,toLocal()) AS xdate, login AS xlogin, | |
| 795 | 795 | @ mimetype as xmimetype, icomment AS xcomment, |
| 796 | 796 | @ username AS xusername |
| 797 | 797 | @ FROM ticketchng |
| 798 | 798 | @ WHERE tkt_id=$tkt_id AND length(icomment)>0} { |
| 799 | 799 | @ if {$seenRow} { |
| @@ -926,12 +926,12 @@ | ||
| 926 | 926 | @ WHEN status='Fixed' THEN '#cfe8bd' |
| 927 | 927 | @ WHEN status='Tested' THEN '#bde5d6' |
| 928 | 928 | @ WHEN status='Deferred' THEN '#cacae5' |
| 929 | 929 | @ ELSE '#c8c8c8' END AS 'bgcolor', |
| 930 | 930 | @ substr(tkt_uuid,1,10) AS '#', |
| 931 | -@ datetime(tkt_ctime) AS 'created', | |
| 932 | -@ datetime(tkt_mtime) AS 'modified', | |
| 931 | +@ datetime(tkt_ctime,toLocal()) AS 'created', | |
| 932 | +@ datetime(tkt_mtime,toLocal()) AS 'modified', | |
| 933 | 933 | @ type, |
| 934 | 934 | @ status, |
| 935 | 935 | @ subsystem, |
| 936 | 936 | @ title, |
| 937 | 937 | @ comment AS '_comments' |
| 938 | 938 |
| --- src/tktsetup.c | |
| +++ src/tktsetup.c | |
| @@ -603,11 +603,11 @@ | |
| 603 | @ } |
| 604 | @ } |
| 605 | @ } |
| 606 | @ set seenRow 0 |
| 607 | @ set alwaysPlaintext [info exists plaintext] |
| 608 | @ query {SELECT datetime(tkt_mtime) AS xdate, login AS xlogin, |
| 609 | @ mimetype as xmimetype, icomment AS xcomment, |
| 610 | @ username AS xusername |
| 611 | @ FROM ticketchng |
| 612 | @ WHERE tkt_id=$tkt_id AND length(icomment)>0} { |
| 613 | @ if {$seenRow} { |
| @@ -789,11 +789,11 @@ | |
| 789 | @ </tr> |
| 790 | @ |
| 791 | @ <th1> |
| 792 | @ set seenRow 0 |
| 793 | @ set alwaysPlaintext [info exists plaintext] |
| 794 | @ query {SELECT datetime(tkt_mtime) AS xdate, login AS xlogin, |
| 795 | @ mimetype as xmimetype, icomment AS xcomment, |
| 796 | @ username AS xusername |
| 797 | @ FROM ticketchng |
| 798 | @ WHERE tkt_id=$tkt_id AND length(icomment)>0} { |
| 799 | @ if {$seenRow} { |
| @@ -926,12 +926,12 @@ | |
| 926 | @ WHEN status='Fixed' THEN '#cfe8bd' |
| 927 | @ WHEN status='Tested' THEN '#bde5d6' |
| 928 | @ WHEN status='Deferred' THEN '#cacae5' |
| 929 | @ ELSE '#c8c8c8' END AS 'bgcolor', |
| 930 | @ substr(tkt_uuid,1,10) AS '#', |
| 931 | @ datetime(tkt_ctime) AS 'created', |
| 932 | @ datetime(tkt_mtime) AS 'modified', |
| 933 | @ type, |
| 934 | @ status, |
| 935 | @ subsystem, |
| 936 | @ title, |
| 937 | @ comment AS '_comments' |
| 938 |
| --- src/tktsetup.c | |
| +++ src/tktsetup.c | |
| @@ -603,11 +603,11 @@ | |
| 603 | @ } |
| 604 | @ } |
| 605 | @ } |
| 606 | @ set seenRow 0 |
| 607 | @ set alwaysPlaintext [info exists plaintext] |
| 608 | @ query {SELECT datetime(tkt_mtime,toLocal()) AS xdate, login AS xlogin, |
| 609 | @ mimetype as xmimetype, icomment AS xcomment, |
| 610 | @ username AS xusername |
| 611 | @ FROM ticketchng |
| 612 | @ WHERE tkt_id=$tkt_id AND length(icomment)>0} { |
| 613 | @ if {$seenRow} { |
| @@ -789,11 +789,11 @@ | |
| 789 | @ </tr> |
| 790 | @ |
| 791 | @ <th1> |
| 792 | @ set seenRow 0 |
| 793 | @ set alwaysPlaintext [info exists plaintext] |
| 794 | @ query {SELECT datetime(tkt_mtime,toLocal()) AS xdate, login AS xlogin, |
| 795 | @ mimetype as xmimetype, icomment AS xcomment, |
| 796 | @ username AS xusername |
| 797 | @ FROM ticketchng |
| 798 | @ WHERE tkt_id=$tkt_id AND length(icomment)>0} { |
| 799 | @ if {$seenRow} { |
| @@ -926,12 +926,12 @@ | |
| 926 | @ WHEN status='Fixed' THEN '#cfe8bd' |
| 927 | @ WHEN status='Tested' THEN '#bde5d6' |
| 928 | @ WHEN status='Deferred' THEN '#cacae5' |
| 929 | @ ELSE '#c8c8c8' END AS 'bgcolor', |
| 930 | @ substr(tkt_uuid,1,10) AS '#', |
| 931 | @ datetime(tkt_ctime,toLocal()) AS 'created', |
| 932 | @ datetime(tkt_mtime,toLocal()) AS 'modified', |
| 933 | @ type, |
| 934 | @ status, |
| 935 | @ subsystem, |
| 936 | @ title, |
| 937 | @ comment AS '_comments' |
| 938 |