"select strftime('%m',datetime('now'))='06'"
1
"select strftime('%m',datetime('now'))=6"
0
It is considered as a string, not a number.
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
> [email protected]
> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
