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