Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
14 lines (13 sloc) 197 Bytes
select
TYPE,
PATH,
datetime(DATE/1000, 'UNIXEPOCH', 'LOCALTIME') as DATE,
LATITUDE,
LONGITUDE,
WAS_DELETED,
FILE_SIZE_BYTES,
FILE_SIZE_BYTES/1e+6 as FILE_SIZE_MBYTES,
WIDTH,
HEIGHT
from
MEDIA_ITEM