SHA1 Hash:	aad573b31cde9dfe8cfadd26c27e3ac07bcce6f3
Date:	2007-09-24 20:50:30
User:	mjanssen
Comment:	Timeline calculated localtime incorrectly so it didn't display latest changes if user is in TZ UTC+X
Timelines:	ancestors | descendants | both | trunk
Other Links:	files | ZIP archive | manifest

• branch=trunk inherited from [a28c83647d]
• sym-trunk inherited from [a28c83647d]

Modified src/timeline.c from [dc980b14e8] to [19a54bcbde].

@@ -443,11 +443,11 @@
 const char *timeline_query_for_tty(void){
   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
     @ WHERE blob.rid=event.objid
@@ -522,11 +522,11 @@
   blob_append(&uuid, zOrigin, -1);
   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 ){
     objid = db_int(0, "SELECT rid FROM blob WHERE uuid=%B", &uuid);