@Franklin52
I already saw that the fieldseparator was missing...

But, even if I use the fieldseparator, there's still the probleme which i tried to translate. It seems that there's a problem with the date syntax, or something like that.

BTW:
If I write this at the commandline

echo "1265911223 www.google.com"|awk '{str="date -d @"$1; print system(str)}'
this is the result

Code:

Do 11. Feb 19:00:23 CET 2010
0

@pludi

Hey pludi,

also an interesting way. But also in your example there's a problem modifying the date. If I try your code, the result is this

Code:

date: ungültiges Datum „@126364422;http://www.google.de/“

date: ungültiges Datum „@126364535;http://www.google.de/“

date: ungültiges Datum „@126364535;http://www.google.de/#hl=de&source=hp&q=unix+forum&btnG=Google-Suche&meta=&aq=f&oq=unix+forum&fp=749e75dee4f1c52f“

date: ungültiges Datum „@126364536;https://www.unix.com/“

date: ungültiges Datum „@126364538;https://www.unix.com/shell-programming-scripting/“

date: ungültiges Datum „@126364547;http://www.google.de/“

date: ungültiges Datum „@126364556;http://www.google.de/“

By the way. It seems that you know the firefox databases. Do you know where exactly the visit date is stored. I've searched a long time, but I didn't get the right answer. In my moz_places in places.sqlite is a value called last_visit_date. In your example, you used the visit_date from the moz_historyvisit table. Is there an difference between these two values? The problem is, that I didn't found any information about last_visit_date at all, but I found information about the value you used (visit_date in moz_historyvisit). If yours is the right one, I would prefer your way to extract the date and URL...