|
From: | Derek Scherger |
Subject: | Re: [Monotone-devel] Monotone displays commit times in UTC, not local time |
Date: | Fri, 06 Jun 2008 23:06:22 -0600 |
User-agent: | Thunderbird 2.0.0.12 (X11/20080303) |
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:33Seems 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
[Prev in Thread] | Current Thread | [Next in Thread] |