Maybe. Also there's a question when I wanted to ask in the first
letter too: where did you get function year() from? I don't see it in
http://www.sqlite.org/lang_datefunc.html and my sqlite3 doesn't see it
too:
sqlite> select year(date('now'));
SQL error: no such function: year
Maybe it's SQLite developer who registers it as user-defined function?
So you better to look into its documentation and learn what date
format it understands.
Pavel
On Wed, Sep 16, 2009 at 1:05 PM, vbshar <shar...@terra.com.br> wrote:
>
> I think the problem is in field format ou data format, because if i insert
> data from my app SQLite does not return any value, but if i insert data with
> the manager "SQLite developer"; the query works...
>
> Pavel Ivanov-2 wrote:
>>
>> Did you try to put 1946 without quotes?
>>
>> Pavel
>>
>> On Wed, Sep 16, 2009 at 12:21 PM, vbshar <shar...@terra.com.br> wrote:
>>>
>>> Hi,
>>>
>>> I have a table called PEOPLE with 2 fiels:
>>>
>>> NAME à TEXT 40
>>> BIRTH à DATETIME
>>>
>>> With some records
>>>
>>> I want to filter all people with BIRTH = 1946, I’m trying this:
>>>
>>> SELECT * FROM PEOPLE WHERE YEAR(PEOPLE.BIRTH)=’1946’;
>>>
>>> There are several people in this year, but recordset all time returns 0
>>> records… what's the problem?
>>>
>>>
>>> Best Regards
>>> Paulo
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Select-records-by-specific-YEAR-tp25475857p25475857.html
>>> Sent from the SQLite mailing list archive at Nabble.com.
>>>
>>> _______________________________________________
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/Select-records-by-specific-YEAR-tp25475857p25476648.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
