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
Hi Yepoleb, just to let you know this 2 games are not showing prices correctly:

-Unreal Tournament 2004 Editor's Choice Edition
-Unreal Tournament GOTY

I was also wondering if would be possible to add the System requirements info to the gogdb

Regards and Thanks again for the great resource gogdb is :)