SQLITE3 date and interval function

I want to know whether sqlite3 supports the interval function. PostgreSQL accepts the following statement, but sqlite3 cannot parse it;

select< br /> ...
from
orders
where
...
and o_orderdate

Error: near line 4: near "'1995-03-01'": syntax error

Then, I modified some declarations, such as;

and o_orderdate 

This time the error is;
Error: near line 4: near " '3'": Syntax error

Unfortunately, the same technique does not work for the interval function, ie

and o_orderdate 

or

and o_orderdate 

even

and o_orderdate  

Still giving me a syntax error.

Maybe sqlite3 does not support the interval function or I missed its usage?

Thank you very much

and o_orderdate 

reference of date and time functions in SQLite

I want to know whether sqlite3 supports interval functions. PostgreSQL accepts the following statement, but sqlite3 cannot parse it;

select
...
from
orders
where
...
and o_orderdate

Error: near line 4: near "'1995-03- 01'”: Syntax error

Then, I modified some statements, such as;

and o_orderdate 

This time the error is;
Error: Near line 4: Near "'3'": Syntax error

Unfortunately, the same The trick does not work for the interval function, that is

and o_orderdate 

Either

and o_orderdate 

even

< p>

and o_orderdate 

It still gives me syntax errors.

Maybe sqlite3 does not support the interval function or am I missing its usage?

Thank you very much

and o_orderdate  

reference of date and time functions in SQLite

Leave a Comment

Your email address will not be published.