SQLite equivalent of SQL Server DateAdd function

Question

I need help reproducing the following SQL statement to a statement that SQLite understands.

SELECT * FROM SomeTable WHERE [Date] >= DATEADD(day, -14, GETDATE())

Any help is much appreciated!

Answer 1

From this link

Date And Time Functions

it would seem that you can use something like

date(timestring, modifier, modifier, ...) 

SELECT date('now','+14 day'); 

Does this seem correct to you?

Answer 2

The method Adriaan Stander gives result in GMT

You can do it in LocalTime like this

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