Neat. As a Firefox user, it appears that this does the trick:
sqlite3 ~/.mozilla/firefox/$YOUR_PROFILE_ID/places.sqlite "SELECT datetime(visit_date/1000000,'unixepoch'),url FROM moz_historyvisits JOIN moz_places ON place_id=moz_places.id ORDER BY visit_date DESC" > hist.txt
(Looks like the timestamp is in UTC here.)----
Does the original post's code perhaps count two visits to the same URL as one? Something like
SELECT datetime(visit_time/1000000-11644473600,'unixepoch'),urls.url
FROM visits JOIN urls ON visits.url=urls.id
ORDER BY visit_time DESC;
might be worth a try.