Re: [sqlite] Sqlite DATE() function. Add a variable amount of months.

nth'); > > You can do like this: > > SELECT date('now','+' || (SELECT id FROM table) || ' month'); > > > Pavel > > > On Wed, Jun 8, 2011 at 1:42 PM, datepb <kevin.guille...@etu.enseeiht.fr> > wrote: >> >> Hello, >> >> This may

[sqlite] Sqlite DATE() function. Add a variable amount of months.

Hello, This may seem a very simple issue it is giving me some very hard time. I need to add a variable amount of months to a date. According to the doc, this is done for adding 1 month : SELECT date('now','+1 month'); And I would need something like SELECT date('now','+$i month'); This