Re: [sqlite] Variable value vs Static inside the Sqlite datetime function.

2018-08-22 Thread Richard Hipp
On 8/21/18, Fim Wästberg wrote: > Will I works even If the date is 2018-12-18 ? How hard is it to try and see for yourself? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlit

Re: [sqlite] Variable value vs Static inside the Sqlite datetime function.

2018-08-22 Thread Fim Wästberg
Will I works even If the date is 2018-12-18 ? Fim Wästberg, Sweden -Ursprungligt meddelande- Från: sqlite-users För Richard Hipp Skickat: den 21 augusti 2018 13:01 Till: SQLite mailing list Ämne: Re: [sqlite] Variable value vs Static inside the Sqlite datetime function. On 8/19/18

Re: [sqlite] Variable value vs Static inside the Sqlite datetime function.

2018-08-21 Thread Richard Hipp
On 8/19/18, Misfer Al-Shamrani wrote: > Hi everyone, > > I’m looking for the proper presentation (syntax) that will use a dynamic > value from the table instead of a fixed value as given in the common example > below: > > SELECT date('now','+1 month’); > > = 2018-09-18 > > I want to replace the (

[sqlite] Variable value vs Static inside the Sqlite datetime function.

2018-08-21 Thread Misfer Al-Shamrani
Hi everyone, I’m looking for the proper presentation (syntax) that will use a dynamic value from the table instead of a fixed value as given in the common example below: SELECT date('now','+1 month’); = 2018-09-18 I want to replace the ( “+1” ….. months) with a dynamic value from my table fie