I want to store my installed packages to SQLite This is mostly useless for most of people on the world, and this blog post is more a note to myself. sqlite> CREATE TABLE packages (id INTEGER PRIMARY KEY, package TEXT); sqlite> INSERT INTO packages (package) VALUES ('test'); sqlite> INSERT INTO packages (package) VALUES ('test'); sqlite> SELECT * FROM packages ; 1|test 2|test Well, I solved the "SQLIte Auto increment" question! pacman -Q \ | awk '{print "INSERT INTO packages (package) VALUES (\x27"$1"\x27);"; }' \ | sqlite3 packages.sqlite
With PHP I always forget how to get this date format: "2021-02-09T19:04:10+01:00" It is called the ISO 8601 format. And to have it in PHP: php > $date = Date("Y-m-d\TH:i:sP"); php > echo $date; 2021-02-09T19:04:10+01:00 Note about the Z ( reference ) The Z got its letter initial from "zero UTC offset". Letter Z is referred to as "Zulu" in the NATO phonetic alphabet . In turns, the military approach to refer to the zero UTC offset is anchored on letter Z which they identify as Zulu, earning it their coded name: Zulu time zone. It is important to note that the Z has not lost its meaning and still is the zone designator for the zero UTC offset as Zulu time zone (from Z) is simply an inherited coded language to refer to it. So, "2021-02-09T19:04:10+00:00" is the equivalent of "2021-02-09T19:04:10Z".