On Fri, Feb 6, 2009 at 8:09 AM, Helen Borrie <helebor@...> wrote:

>>Is this supposed to be a bug?
>
> Not if it works. ;-)

;-)

>>Shouldn't I have to cast the string to a time just as you described?
>
> If you got it to work with an assignment, then apparently not.
>
> Note, not all contexts of date literals usage require the cast. Pre-IB 6, it
> was allowed in any context where a Dialect 1 DATE was being passed as a
> constant value. Post IB 6, with Dialect 3 databases, some do, some don't.
> The trick is to know which contexts need the cast and which don't...and then
> another version comes out and the rules change again.
>
> So, IMO, it's wise to do the cast in all contexts but particularly in a
> situation where not casting causes an exception.

Well, I normally do the cast, and since you previously mentioned that
From IB 6 onwards we had to add casting all over the place, I thought
it shouldn't work. But if it does, then I guess it should behave like
that.

Thanks for clearing that out.

Fidel.