[Gambas-user] sql query year problem

[R. Stormo]

I have tried the strftime but it does not work. This is what I get in the
database manager
SELECT fakturanr, dato FROM mytable WHERE strftime('%Y',dato) = '2006' 
--
No records
--
When I try it like this
SELECT fakturanr, dato FROM mytable
I get my records
..
1006 - 12/10/2005
1007 - 1/27/2006
..

-- 
Regards
	Rohnny Stormo


-----------------------------------------
Gambas brings Basic to Linux.
My Gambas Community http://forum.stormweb.no
--
View this message in context: http://www.nabble.com/sql-query-year-problem-t1230734.html#a3256834
Sent from the gambas-user forum at Nabble.com.