Re: [sqlite] weekday time modifier

ions. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of D Burgess >Sent: Sunday, 23 September, 2018

Re: [sqlite] weekday time modifier

select strftime('%Y-%m-%d %H:%M', '2018-09-23 8:59', 'localtime','weekday 0'); Also gets a bit confusing. The "weekday" operates on the UTC time. On Sun, Sep 23, 2018 at 11:42 PM, Kevin Martin wrote: > Hi, > > Not sure if this is me misreading it, but the description of the weekday >

[sqlite] weekday time modifier

Hi, Not sure if this is me misreading it, but the description of the weekday modifier in the documentation seems a bit ambiguous. It says: > The "weekday" modifier advances the date forward to the next date where the > weekday number is N. Sunday is 0, Monday is 1, and so forth. It is not