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

[Derek Scherger]

Thomas Moschny wrote:
> % 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.

Seems to work here too, although with the binary revision ids in my 
database the queries look a bit different.

$ mtn db execute 'select value, datetime(value, "localtime") from 
revision_certs where 
lower(hex(id))="8c73def6c2654cc7fb8b11ef2d37d239885383a7" and name="date"'

2008-02-23T00:26:48 | 2008-02-22 17:26:48

MST (UTC-7)

$ mtn db execute 'select value, datetime(value, "localtime") from 
revision_certs where 
lower(hex(id))="f69cf74dc58898f1cf5ee764132bddae100bd041" and name="date"'

2008-04-01T20:06:50 | 2008-04-01 14:06:50

MDT (UTC-6)

Cheers,
Derek