On 3/14/16, Luca Ferrari <fluca1978 at infinito.it> wrote:
> Hi all,
> I suspect I've a wrong timezone, even if I cannot understand how and why.
> I've got atable with a column defined as follows:
>
> ts timestamp DEFAULT CURRENT_TIMESTAMP
>
> this should get default values in GMT. Now if I try to compare a row
> inserted a few minutes before (without the ts value, so with the
> default) with the current timestamp I got 'now' is before the row
> timestamp:
>
> SELECT strftime('%s', ts ), ts, strftime( '%s', CURRENT_TIMESTAMP ),
> CURRENT_TIMESTAMP FROM ....
> 1457949984|2016-03-14 10:06:24|1457948222|2016-03-14 09:37:02
>
> So the row appear to be one hour in the future.
> I kindly ask how to fix this and how to safely check all the already
> inserted tuples (e.g., update their ts values).
>
I think your system clock was set incorrectly when you did the initial insert.
--
D. Richard Hipp
drh at sqlite.org
