Subject Re: [firebird-support] Re: 1=1 in where gets a bad performance
Author Anderson Farias
Hi,


> No, I don't mean *why* do you use them. I mean, how do you manage to use
> them and avoid getting validation errors. I mean that 'mm/dd/yyyy' is
> the only valid date literal format that uses the slash separator. So I
> was (and am still) curious as to how you avoid the exceptions.
>

It just works. Try for yourself

select cast('2008/11/15' as date) from rdb$database;


Only note that the year part must have 4 digits or Firebird will think
you're using the 'mm/dd/yy' format.

Regards,
Anderson Farias