--- In firebird-support@yahoogroups.com, "Anderson Farias"
<peixedragao@...> wrote:

>
> Hi,
>
> > Is this legal SQL or what did I overlook? Speed is no issue here, the
> > database is very small and will grow very slowly.
>
> I supose this is kind a 'lucky' result. The string representation

for dates

> (dates CASTed to varchar) in firebird is 'yyyy-mm-dd' so, it matches

the

> 'yyyy-mm' format you're using
>

Yes - this is documented anyway. But I wouldn't have expected any
implicit cast, and after looking it up in The Book I'm still surprised
about it. Should perhaps have been clearer about this in my first posting.