[sqlite] date - SQL extraction from day, month and year

2006-12-26 Thread Karsten Koschinski
Hey, I have a database with a field where dates are stored! As everybody knows SQLite has no special date support such as a special datatype for date or something else. Now I want to select only those records, where the year ist e.g. 2005. How can I do this? "SELECT * FROM database WHERE

Re: [sqlite] [finished] date - SQL extraction from day, month and year

2006-12-26 Thread Karsten Koschinski
That's the solution! It works fine! Thanks RBS and for all answers! Unfortunately I read this some hours ago on the wiki - but I wasn't able to understand and use it - too impatient! Sorry! To my defense I have to say, that I'm a MS ACCESS user learning SQLite and qt! ;-) Now as I do know