Skip to content

Instantly share code, notes, and snippets.

@ziggear

ziggear/gist:8251551

Created January 4, 2014 04:10
Show Gist options
  • Save ziggear/8251551 to your computer and use it in GitHub Desktop.
Save ziggear/8251551 to your computer and use it in GitHub Desktop.
Download ZIP
my sqlite scripts
Raw
gistfile1.sql
-- select hunman readable time from a unix timestamp
select
latitude,longitude,datetime(time / 1000, 'unixepoch', 'localtime') as time
from UploadedGPSPoints order by -time;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment