Re: [Monotone-devel] Monotone displays commit times in UTC, not local time

[Thomas Moschny]

On Thursday 05 June 2008, Zack Weinberg wrote:
> On Thu, Jun 5, 2008 at 12:26 PM, Nuno Lucas <address@hidden> 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.