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

> 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??

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

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

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.

[sqlite] typeless / bug or feature??

hi, sqlite is typeless. OK! but how can i save dates in sqlite because i need dates in my query...?? 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