[Gambas-user] sql query year problem

[R. Stormo]

Looking for a solution to select records from a choosen year. Would be
perfect if the same sql works for postgres and sqlite3
In MsSql it would be done like this.
SELECT id, dato FROM mytable WHERE year(dato)=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-t1227953.html#a3247550
Sent from the gambas-user forum at Nabble.com.