I used SQL Studio to build 2 queries:
1. in SQL, it's working fine:
SELECT * FROM my_tab
WHERE my_tab.START_DA TE between '2006-01-01' and '2006-12-31'
2. but if I build the same thing in visual query, it complains there's an error and highlight "d '2006-12-31'"

Appreciate anyone could comment on MySQL's complaints.

So far, MySQL is quite a piece of work for anyone who used Oracle...