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).
Thanks,
Luca
