SQLite Forum

(Deleted)
Login

strftime showing wrong time

(1) By curmudgeon on 2020-08-01 12:05:54 updated by 1.1

Does anyone have any idea why this might be happening.

My VPN is off.

My windows 10 time region is set to '(UTC+00.00) Dublin, Edinburgh, Lisbon, london', Adjust for daylight saving time automatically is set. Regardless of whether the 'Set the time automatically' and 'Set the time zone automatically' options are on or off the laptop clock shows 12:28. Current time on the internet shows 12:28.

In sqlite

select strftime('%Y/%m/%d %H:%M:%S','now');

returns 11:28.

I've tried resetting the time zone and time and rebooting.

strftime when used directly in a c programme returns 12:28.

(1.1) By curmudgeon on 2020-08-01 12:07:55 edited from 1.0 [link]

Deleted