[sqlite] Optimising max(datetime()) queries.

On 2016/05/21 5:12 PM, Jonathan wrote: > Hi List, > I've come across a little curiousity and was wondering what was going > on (and if there's an even better way). > > I have some DATETIME data: > > 2013-06-03 16:08:55+01:00 > 2013-06-03 16:46:22+00:00 > 2013-06-03 16:48:57+00:00 > ... > > I wan

[sqlite] Optimising max(datetime()) queries.

Hi List, I've come across a little curiousity and was wondering what was going on (and if there's an even better way). I have some DATETIME data: 2013-06-03 16:08:55+01:00 2013-06-03 16:46:22+00:00 2013-06-03 16:48:57+00:00 ... I want to get the the start of the day that was 28 days ago from th