| Subject | Re: [ib-support] sql statement. |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-10-31T01:38:14Z |
At 08:41 AM 31-10-02 +0800, you wrote:
WHERE
... <other criteria>
AND
(EXTRACT(MONTH FROM datecolumn) = 2
OR
EXTRACT(MONTH FROM datecolumn) = 9)
AND
...
heLen
>thanks..
>actually i was trying tto find the month feb and sep.
WHERE
... <other criteria>
AND
(EXTRACT(MONTH FROM datecolumn) = 2
OR
EXTRACT(MONTH FROM datecolumn) = 9)
AND
...
heLen