On 23 Jun 2013, at 8:45pm, Lucas <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
