[HELP] How to add +1 month to current date [MYSQL]

[syxx1337]

Hello!

So, I want to put +1 month from now to the mysql data but it's just insert current date (2018.01.24).. why?!

date = string.format("%04d.%02d.%02d", time.year + 1900, time.month + 10, time.monthday )
	dbExec(connection, "UPDATE Identity SET expires=? WHERE value = ?", date,itemValue)

 

[DRW]

3 hours ago, syxx1337 said:

Hello!

So, I want to put +1 month from now to the mysql data but it's just insert current date (2018.01.24).. why?!

date = string.format("%04d.%02d.%02d", time.year + 1900, time.month + 10, time.monthday )
	dbExec(connection, "UPDATE Identity SET expires=? WHERE value = ?", date,itemValue)

 

Because the month range is 0-11 (It does not count months like that, it calculates months passed since January, so from January to February a month passes, then February is 1, from January to December, 11 months pass, so December is 11). Your script actually works since the month 1 is February.

Edited January 24, 2018 by MadnessReloaded

[syxx1337]

7 hours ago, MadnessReloaded said:

Because the month range is 0-11 (It does not count months like that, it calculates months passed since January, so from January to February a month passes, then February is 1, from January to December, 11 months pass, so December is 11). Your script actually works since the month 1 is February.

Thanks for your reply, but then how can I add +1 month from now?

[DRW]

Just now, syxx1337 said:

Thanks for your reply, but then how can I add +1 month from now?

Month + 1

[kieran]

See where you have

time.month

Add this bit of code where you want to add +1

time.month = (tonumber(time.month)) + 1 --This should do time.month = the month converted to a number plus one

Edited January 24, 2018 by kieran