Subject Re: WHERE mydate STARTING WITH 'ccyy-mm'
Author skoczian
--- In, "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
> '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.