CarissaDurko/localtime.sql

Created July 7, 2025 18:03

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/CarissaDurko/ee67226a9c64fb79c89dc91045f042a5.js"></script>
Save CarissaDurko/ee67226a9c64fb79c89dc91045f042a5 to your computer and use it in GitHub Desktop.

Download ZIP

SQL Sort Browser History by Local Time

Raw

localtime.sql

	SELECT url,title,datetime(last_visit_time/ 1000000 + (strftime('%s','1601-01-01')),'unipoch','localtime')
	FROM urls
	ORDER BY last_visit_time DESC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment