You can write: "select cast(strftime('%m',datetime('now')) as integer)=6" 1
On 06/23/2013 09:45 PM, Lucas wrote: > Hello, > > I am testing SQLIte as we are considering to change our DB Server but I > found that a feature is missing, the function Month: > > SELECT SUM( NINGRESO ) AS ndev FROM APUNTES WHERE MONTH(FECHA) = 1 > > This works perfect under MySQL or MSSQL. > > Do you plan to introduce MONTH and YEAR functions?. > > > Also, the function strftime('%m', fecha) does not solve the issue: > > SELECT SUM( NINGRESO ) AS ndev FROM APUNTES WHERE strftime('%m', fecha) = 1 > > > Please, any idea of how to solve it. > > > Thank you. Best regards, > > Lucas de Beltran > Caritas EspaƱa > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- ASCII ribbon campaign ( ) against HTML e-mail X www.asciiribbon.org / \ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users