select< br /> ...
from
orders
where
...
and o_orderdateError: near line 4: near "'1995-03-01'": syntax error
Then, I modified some declarations, such as;
and o_orderdateThis time the error is;
Error: near line 4: near " '3'": Syntax errorUnfortunately, the same technique does not work for the interval function, ie
and o_orderdateor
and o_orderdateeven
and o_orderdateStill giving me a syntax error.
Maybe sqlite3 does not support the interval function or I missed its usage?
Thank you very much
and o_orderdatereference 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_orderdateError: near line 4: near "'1995-03- 01'”: Syntax error
Then, I modified some statements, such as;
and o_orderdateThis time the error is;
Error: Near line 4: Near "'3'": Syntax errorUnfortunately, the same The trick does not work for the interval function, that is
and o_orderdateEither
and o_orderdateeven
< p>
and o_orderdateIt 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_orderdatereference of date and time functions in SQLite