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