[Gambas-user] sql query year problem

[Rob Kudla]

On Sun March 5 2006 23:22, R. Stormo wrote:
> 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

Are you using Sqlite 3?  I don't think that worked in Sqlite 2.

Rob