filter middle field
Posted: Wed Feb 10, 2010 10:15 pm
I have a problem... i want to filter my table on date field for month... n my code like this :
"SELECT * FROM table WHERE substr(datefield,5,2)='02' ";
correct please ...
"SELECT * FROM table WHERE substr(datefield,5,2)='02' ";
correct please ...