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!

score 45 · Accepted Answer · answered Dec 04 '09 at 08:30

45

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?

answered Dec 04 '09 at 08:30

Adriaan Stander

1

SQLite appears to lose the time portion of the column values, if there is any. SQL Server would have kept those for a DATETIME or SMALLDATETIME type. Just an observation. – Magnus Smith Nov 02 '15 at 12:27
SELECT date('2019-12-17 14:19:19','+14 day'); would lose the time part. – Zhang Dec 17 '19 at 06:19
1

@MagnusSmith, datetime(timestring, modifier, modifier, ...) would be fine. – Zhang Dec 17 '19 at 06:21

score 5 · Answer 2 · answered Sep 17 '15 at 10:02

5

The method Adriaan Stander gives result in GMT

You can do it in LocalTime like this

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

answered Sep 17 '15 at 10:02

Abdul Saleem

2 Answers2