sqlite3 date and interval functions
- by umuthorax
Hi,
I wonder whether sqlite3 supports interval function. The following statement is accepted by PostgreSQL, however sqlite3 failed to parse it;
select
...
from
orders
where
...
and o_orderdate < date '1995-03-01' + interval '3' month
Error: near line 4: near "'1995-03-01'": syntax error
Then, I modified the statement a little bit such…
