Differences From:

File src/timeline.c part of check-in [ff4cc5fae2] - Fixes to the timeline webpage and the "open" and "update" commands. by drh on 2007-09-23 18:49:50. [view]

To:

File src/timeline.c part of check-in [aad573b31c] - Timeline calculated localtime incorrectly so it didn't display latest changes if user is in TZ UTC+X by mjanssen on 2007-09-24 20:50:30. [view]

@@ -444,9 +444,9 @@
   static const char zBaseSql[] =
     @ SELECT
     @   blob.rid,
     @   uuid,
-    @   datetime(event.mtime,'localtime'),
+    @   datetime(event.mtime,'utc'),
     @   coalesce(ecomment,comment) || ' (by ' || coalesce(euser,user) || ')',
     @   (SELECT count(*) FROM plink WHERE pid=blob.rid AND isprim),
     @   (SELECT count(*) FROM plink WHERE cid=blob.rid)
     @ FROM event, blob
@@ -523,9 +523,9 @@
   if( strcmp(zOrigin, "now")==0 ){
     if( mode==3 || mode==4 ){
       fossil_fatal("cannot compute descendents or ancestors of a date");
     }
-    zDate = mprintf("(SELECT julianday('now','utc'))");
+    zDate = mprintf("(SELECT datetime('now'))");
   }else if( strncmp(zOrigin, "current", k)==0 ){
     objid = db_lget_int("checkout",0);
     zDate = mprintf("(SELECT mtime FROM plink WHERE cid=%d)", objid);
   }else if( name_to_uuid(&uuid, 0)==0 ){