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

Reply via email to