If I understand what has been said - I am surprised the the import gets the URLs OK but does not correctly import the dates, or rather seems to stamp them at the time of the import. What would be the logic of this? Thats why I would like to see the raw dates and see if that tells us anything
That's a good questions, and I'm not entirely sure on that. The URLs table won't tell you much beyond the URL and last visit date/time but if there are other entries in the visits or visit_source tables, you can pull the transition type (typed, link, form submit, etc.) and whether it was sync'ed or not which should be able to confirm if it was an import or how those URLs were accessed. Here's a list of definitions from the Chrome source
https://
Jamie