Subject Re: [ib-support] Re: Strange query results, based on where clause
Author Woody
From: "Ann W. Harrison" <aharrison@...>
>
> You'd outlaw
>
> select id from whatever where entry_date > 'Feb 22 1987'?
>

Now, Ann, I think you'd agree that some data types must be expressed using
some valid formatting, such as dates and times. How else could they be
represented or interpreted? However, definitive number and string types are
different animals, IMO. I remember a discussion a while back on this group
about delimiting dates using a particular character, such as the # (hash)
mark like Access does, etc. Not all databases allow you to use a string
value to compare dates. Also, IIRC, IB and FB only recognize dates in
certain formats as well. So, I think there is precedence for my way of
thinking. It may not be universal, but it does exist. :)

Woody (TMW)