Fossil SCM
Display the last modification time of tickets using either localtime or UTC according to user preferences.
Commit
839f105098f1091d276b711a0368aa7710d907b7
Parent
0b9371365dd4434…
1 file changed
+1
-1
+1
-1
| --- src/tkt.c | ||
| +++ src/tkt.c | ||
| @@ -101,11 +101,11 @@ | ||
| 101 | 101 | const char *zName; |
| 102 | 102 | Stmt q; |
| 103 | 103 | int i, n, size, j; |
| 104 | 104 | |
| 105 | 105 | zName = PD("name","-none-"); |
| 106 | - db_prepare(&q, "SELECT datetime(tkt_mtime) AS tkt_datetime, *" | |
| 106 | + db_prepare(&q, "SELECT datetime(tkt_mtime,'localtime') AS tkt_datetime, *" | |
| 107 | 107 | " FROM ticket WHERE tkt_uuid GLOB '%q*'", zName); |
| 108 | 108 | if( db_step(&q)==SQLITE_ROW ){ |
| 109 | 109 | n = db_column_count(&q); |
| 110 | 110 | for(i=0; i<n; i++){ |
| 111 | 111 | const char *zVal = db_column_text(&q, i); |
| 112 | 112 |
| --- src/tkt.c | |
| +++ src/tkt.c | |
| @@ -101,11 +101,11 @@ | |
| 101 | const char *zName; |
| 102 | Stmt q; |
| 103 | int i, n, size, j; |
| 104 | |
| 105 | zName = PD("name","-none-"); |
| 106 | db_prepare(&q, "SELECT datetime(tkt_mtime) AS tkt_datetime, *" |
| 107 | " FROM ticket WHERE tkt_uuid GLOB '%q*'", zName); |
| 108 | if( db_step(&q)==SQLITE_ROW ){ |
| 109 | n = db_column_count(&q); |
| 110 | for(i=0; i<n; i++){ |
| 111 | const char *zVal = db_column_text(&q, i); |
| 112 |
| --- src/tkt.c | |
| +++ src/tkt.c | |
| @@ -101,11 +101,11 @@ | |
| 101 | const char *zName; |
| 102 | Stmt q; |
| 103 | int i, n, size, j; |
| 104 | |
| 105 | zName = PD("name","-none-"); |
| 106 | db_prepare(&q, "SELECT datetime(tkt_mtime,'localtime') AS tkt_datetime, *" |
| 107 | " FROM ticket WHERE tkt_uuid GLOB '%q*'", zName); |
| 108 | if( db_step(&q)==SQLITE_ROW ){ |
| 109 | n = db_column_count(&q); |
| 110 | for(i=0; i<n; i++){ |
| 111 | const char *zVal = db_column_text(&q, i); |
| 112 |