It seems that you're using an outdated browser. Some things may not work as they should (or don't work at all).
We suggest you upgrade newer and better browser like: Chrome, Firefox, Internet Explorer or Opera

×
avatar
Yepoleb: Convert your timestamp to Unix time with something like this:
datetime.datetime.fromisoformat("2017-10-07T19:24:10.409053+00:00").timestamp()
Now use that value to query. Don't touch any SQL native date function, make sure to do everything in Unix time while in database land. Sorry for putting you through this :(.
avatar
phaolo: Oh, no problem.
Btw, I ended up using this:

SELECT strftime('%Y-%m-%d %H:%M:%S',timestamp,'unixepoch') "Date", product_id, product_title, dl_type, bonus_type, action, serialized_record
FROM changelog
WHERE "dl_type" = 'bonus' AND timestamp >= strftime('%s','2021-01-01 00:00:00');

It seems to work correctly, should I really use that huge date conversion? O_o
Now I wonder if I could extract also the data I need from "serialized_record"..
Don't forget that there in 2036 the Unix time stamp will overflow.
avatar
coffeecup: Don't forget that there in 2036 the Unix time stamp will overflow.
Isn't that an issue just for old 32bit systems?
Hopefully, Gog, Gogdb and me will still exist by 2038 to see if it still works XD