Subject | Re: [firebird-support] Re: 1=1 in where gets a bad performance |
---|---|
Author | Anderson Farias |
Post date | 2008-11-15T11:46:37Z |
Hi,
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
> No, I don't mean *why* do you use them. I mean, how do you manage to useIt just works. Try for yourself
> 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.
>
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