Fossil SCM
minor type-cast addition in json timeline SQL.
Commit
70e41ccd4830323579ebe42400cc0961f9bdd4ca
Parent
9262546e4381bed…
1 file changed
+1
-1
+1
-1
| --- src/json_timeline.c | ||
| +++ src/json_timeline.c | ||
| @@ -97,11 +97,11 @@ | ||
| 97 | 97 | static const char zBaseSql[] = |
| 98 | 98 | @ SELECT |
| 99 | 99 | @ NULL, |
| 100 | 100 | @ blob.rid, |
| 101 | 101 | @ uuid, |
| 102 | - @ strftime('%%s',event.mtime), | |
| 102 | + @ CAST(strftime('%%s',event.mtime) AS INTEGER), | |
| 103 | 103 | @ datetime(event.mtime,'utc'), |
| 104 | 104 | @ coalesce(ecomment, comment), |
| 105 | 105 | @ coalesce(euser, user), |
| 106 | 106 | @ blob.rid IN leaf, |
| 107 | 107 | @ bgcolor, |
| 108 | 108 |
| --- src/json_timeline.c | |
| +++ src/json_timeline.c | |
| @@ -97,11 +97,11 @@ | |
| 97 | static const char zBaseSql[] = |
| 98 | @ SELECT |
| 99 | @ NULL, |
| 100 | @ blob.rid, |
| 101 | @ uuid, |
| 102 | @ strftime('%%s',event.mtime), |
| 103 | @ datetime(event.mtime,'utc'), |
| 104 | @ coalesce(ecomment, comment), |
| 105 | @ coalesce(euser, user), |
| 106 | @ blob.rid IN leaf, |
| 107 | @ bgcolor, |
| 108 |
| --- src/json_timeline.c | |
| +++ src/json_timeline.c | |
| @@ -97,11 +97,11 @@ | |
| 97 | static const char zBaseSql[] = |
| 98 | @ SELECT |
| 99 | @ NULL, |
| 100 | @ blob.rid, |
| 101 | @ uuid, |
| 102 | @ CAST(strftime('%%s',event.mtime) AS INTEGER), |
| 103 | @ datetime(event.mtime,'utc'), |
| 104 | @ coalesce(ecomment, comment), |
| 105 | @ coalesce(euser, user), |
| 106 | @ blob.rid IN leaf, |
| 107 | @ bgcolor, |
| 108 |