| Subject | Re: [ib-support] Search date by month? |
|---|---|
| Author | Lucas Franzen |
| Post date | 2001-09-05T20:12:53Z |
Joe Martinez schrieb:
SELECT * FROM TABLE WHERE BIRTHDAY LIKE '___MAR%'
(or: contain 'MAR', or: LIKE '%MAR%', or: LIKE '__-MAR%', etc.)
Not the fastest one but it also works with IB 5.6
Luc.
>How about:
> Actually, two different versions...
>
> The first is Interbase 5.6. The second is Firebird 0.9.4 Test 1.
>
> -Joe
>
SELECT * FROM TABLE WHERE BIRTHDAY LIKE '___MAR%'
(or: contain 'MAR', or: LIKE '%MAR%', or: LIKE '__-MAR%', etc.)
Not the fastest one but it also works with IB 5.6
Luc.