As of this answert to the popular question, the data model of the Chrome or Chromium Browser stores timestamp as the number of microseconds since first of January, 1601.
Therefore an valid SQL query to search for visits betwen two dates looks like this:
SELECT v_time, urls.url, urls.title FROM
(SELECT
url,
datetime(visit_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch', 'localtime') as v_time
FROM visits
ORDER BY visit_time DESC) as X
LEFT JOIN urls ON X.url = urls.id
WHERE X.v_time > '2023-09-27'
AND X.v_time < '2023-09-30';