diff options
author | Florian Pritz <bluewind@xinu.at> | 2022-05-11 09:58:36 +0200 |
---|---|---|
committer | Florian Pritz <bluewind@xinu.at> | 2022-05-11 09:59:33 +0200 |
commit | 4eda86e49897b5ee5784f621ab7a1d8ce7736d08 (patch) | |
tree | 65063008b8a115a7588d7278431db2be7486132b /dump-ff-history | |
parent | 50545403257391d59a7d5ba2ca53a09c5e839e78 (diff) | |
download | bin-4eda86e49897b5ee5784f621ab7a1d8ce7736d08.tar.gz bin-4eda86e49897b5ee5784f621ab7a1d8ce7736d08.tar.xz |
dump-ff-history: Use local time
Signed-off-by: Florian Pritz <bluewind@xinu.at>
Diffstat (limited to 'dump-ff-history')
-rwxr-xr-x | dump-ff-history | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/dump-ff-history b/dump-ff-history index 5f16837..33cf7f0 100755 --- a/dump-ff-history +++ b/dump-ff-history @@ -5,7 +5,7 @@ trap "rm -rf '${TMPDIR}'" EXIT TERM cp -n ~/.mozilla/firefox/*.default/places.sqlite* "$TMPDIR" -sqlite3 "$TMPDIR/places.sqlite" "SELECT datetime(visit_date/1000000,'unixepoch') AS visit_date, url, title +sqlite3 "$TMPDIR/places.sqlite" "SELECT datetime(visit_date/1000000,'unixepoch', 'localtime') AS visit_date, url, title FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND visit_date/1000000 > $(date +%s -d "${1:-2 months ago}") AND visit_date/1000000 < $(date +%s -d "${2:-now}") ORDER BY visit_date" |