SQLite equivalent of SQL Server DateAdd function

tsql sqlite

From this link

it would seem that you can use something like

date(timestring, modifier, modifier, ...) SELECT date('now','+14 day');

Does this seem correct to you?

tsql sqlite

The method Adriaan Stander gives result in GMT

You can do it in LocalTime like this

select DateTime('Now', 'LocalTime', '+1 Day');

CodeHunter