On Thursday 05 June 2008, Zack Weinberg wrote: > On Thu, Jun 5, 2008 at 12:26 PM, Nuno Lucas <[EMAIL PROTECTED]> wrote: > > Or you could just use the sqlite date/time functions[1] to have it > > return localtime instead of UTC. > > The dates are not stored in a way that would make that possible.
Really? % mtn db execute 'select value, datetime(value, "localtime") from revision_certs where id="05dc2c12e723382d5c6ced4b7b9df9ed63f31bb8" and name="date"' 2008-06-02T14:42:33 | 2008-06-02 16:42:33 Seems correct (CEST (UTC+2) in effect here now). Now take an older revision, say 61a83351.., yields: 2008-01-30T19:13:26 | 2008-01-30 20:13:26 In January, CET (UTC+1) was in effect here. - Thomas
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ Monotone-devel mailing list Monotone-devel@nongnu.org http://lists.nongnu.org/mailman/listinfo/monotone-devel