Re: [sqlite] Question limit use for me of sqlite, I need help, please, Marcelo Paiva, Brasil

On 22 May 2012, at 7:25pm, Marcelo Paiva wrote: > data -> date type -> example -> 22/05/2012 -> diferent -> "22/05/2012" > > question/sentence: select *from tcontsif01 where data>='01/01/2012' and > data<='01/05/2012' SQLite has no datatype for dates. Your data

Re: [sqlite] Question limit use for me of sqlite, I need help, please, Marcelo Paiva, Brasil

Here are the steps you must take: 1. Understand that sqlite3 does not have a DATE type, only text. It does have functions that can work with text strings to be treated as dates, for example strftime(). 2. Convert all your dates in the database and in your programmes to use a text format

[sqlite] Question limit use for me of sqlite, I need help, please, Marcelo Paiva, Brasil

Marcelo Paiva, home user, I am bazilian, I don´t speak or write English, I need help around sqlite?, my question: How question in sqlite the sentence like the sentence in Posthe tgreSQL: data -> date type -> example -> 22/05/2012 -> diferent -> "22/05/2012" question/sentence: select *from