How do I open an .sqlite file?

How can I convert last_visit_time into an actual visit date when I'm using sqlite on my Firefox places.sqlite file?

• Answer:

  By visual inspection of the values associated with the last few sites I visited, it seems that last_visit_time is the number of microseconds since midnight Jan 1 1970 UTC - Unix aficionados would instantly recognize this as epoch time (in microseconds). You'd first want to strip off the microseconds portion (i.e. the last 6 digits). Let's say that leaves you with a integer 1234567890. Then from SQLite itself, it's as easy as the SQL query: SELECT datetime(1234567890, 'unixepoch', 'localtime');