On Ubuntu 20.04.2 LTS, I use the recent2 to log and query my bash history, which uses a sqlite3 database to store the history information.
datetime of running a command is inserted in the sqlite3 database with a
unixepoch format, and it will be converted into
localtime accordingly when retrieved and displayed later.
But I found that it did not perform the correct conversion according to the time zone setting on the machine, as shown below:
werner@X10DAi-00:~$ rm 222222222222222222 rm: cannot remove '222222222222222222': No such file or directory werner@X10DAi-00:~$ recent -fo -w . 2222222222222 rm 222222222222222222 # rtime@ 2021-08-29 10:57:13 werner@X10DAi-00:~$ date Sun 29 Aug 2021 06:57:22 PM CST
I also filed an issue here. Any hints for this problem?