the "localtime" modifier is not respected inside docker environments
Hello,
I am a bit of an amateur when it comes to more low level code so please bear with me if the answer to this issue/question is obvious.
I noticed that the result of the following query is different depending on the environment:
select datetime('now','utc') as UTC, datetime('now','localtime') as LOCAL;
When I run this query on my machine I get an expected result:
go run main.go
# UTC: 2023-04-22 02:33:39 - Local: 2023-04-22 18:33:39
When I run this query inside a docker container the localtime is not respected:
date && date -u
# Sat Apr 22 06:35:15 EDT 2023
# Sat Apr 22 10:35:15 UTC 2023
go run main.go
# UTC: 2023-04-22 10:35:57 - Local: 2023-04-22 10:35:57
I also created a repository here with a reproducible example: https://github.com/fr-ser/modernc-sqlite-time-bug
Does anybody know what the issue might be?
Edited by Sergej Herbert