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
