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 with parts in descending order. This is ISO 8601 (http://pt.wikipedia.org/wiki/ISO_8601) year - month - day (ano - mês - dia) 3. Use 4 digit years like 2012 and not 12. 4. Now it is possible to compare dates in the way you want to do. On Tue, 2012-05-22 at 15:25 -0300, Marcelo Paiva wrote: > 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 tcontsif01 where data>='01/01/2012' and > data<='01/05/2012' > > in sqlite ?????? not type data, only TEXT -> in sqlite 22/05/2012 > like,iqual "22/05/2012" or '22/05/2012', the filter negative, order by > negative, > > negative -> select *from tcontsif01 where data>='01/01/2012' and > data<='01/05/2012' > > order by data -> negative -> order by ASCII in sqlite > > please, one light, please solution, please example, please help me > > I understand datetime, understand strtime please help me, please a example > routine sql for sqlite3 with functions, > > Marcelo Paiva > Stante Santa Catarina - Brasil - here is not tropical here is subtropical > here is cold, but here is Brasil ... please help me > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
