Will I works even If the date is 2018-12-18 ? Fim Wästberg, Sweden -----Ursprungligt meddelande----- Från: sqlite-users <[email protected]> För Richard Hipp Skickat: den 21 augusti 2018 13:01 Till: SQLite mailing list <[email protected]> Ämne: Re: [sqlite] Variable value vs Static inside the Sqlite datetime function.
On 8/19/18, Misfer Al-Shamrani <[email protected]> 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 ( +1 .. months) with a dynamic value from my > table field named Months_Later (integer datatype) to give the date > after the number of months in that field. SELECT date('now',printf('%+d months',tab.Months_Later)) FROM tab; -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
