On 18 Feb 2016 at 10:20, Rob Willett <rob.sqlite at robertwillett.com> wrote:
> I?m sure this is a really dumb question but I?m struggling to > understand why the following SQL is needed for what should be a trivial > SQL expression. > > I?ve minimised the example down to (hopefully) make it simpler. > > I have a table with an ISO date StartTime in it held as a string. I'd be inclined to store your dates as seconds since the epoch. That way arithmetic and comparisons become easy, and your SQL looks simpler. Convert to a string for display. But perhaps your application prevents that for some reason. -- Cheers -- Tim
