On 23 Jun 2013, at 8:45pm, Lucas <lucasdebelt...@gmail.com> wrote:
> Also, the function strftime('%m', fecha) does not solve the issue:
>
> SELECT SUM( NINGRESO ) AS ndev FROM APUNTES WHERE strftime('%m', fecha) = 1
We want to know what format you are storing your dates in. Can you do this:
SELECT fecha FROM apuntes LIMIT 3
and tell us the results ?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
