sqlite database queries

Convert Date in sqlite table

SELECT datetime(BeginTimeStamp,'unixepoch', 'localtime') as d, activityId,SumDistance FROM gc_activities

Summarize by date

SELECT datetime(BeginTimeStamp,'unixepoch', 'localtime') as d, COUNT(activityId),SUM(SumDistance) FROM gc_activities GROUP BY d