Re: [sqlite] typeless / bug or feature??

[Kurt Welgehausen]

> sqlite is typeless. OK!
>
>but how can i save dates in sqlite ...


describes ALL the date/time functionality of SQLite.  You
can store dates as strings or numbers; it's your decision.

Regards

Re: [sqlite] typeless / bug or feature??

[Paolo Vernazza]

how can i realise that, i think its not a good idea to save dates in
this format 20041030 (it means the year 2004, month 10 and 30th day)
to solve my problem---
 

Why do you think that? It is really simple to read, write & compare
what's the matter?
for example i have many rows with each one date (everdy needs a row) from the
beginning of the year 2002 until 2004 and i will start a query where i will get all 
rows
from july of the year 2002 until 2004.

SELEC * FROM mytable WHERE date > '20020701' AND date < '20041231'
Paolo

Re: [sqlite] typeless / bug or feature??

[Will Leshner]

yesso wrote:
hi,
sqlite is typeless. OK!
but how can i save dates in sqlite because i need dates in my
query...??

As long as you store your dates in proper SQL format you should have no trouble querying for them.