Daten für einen Montaszeitraum selektieren?

[joachimd]

Delphi-Quellcode:

strquery := 'select * from Adressen where extract(month from sysdate) = extract(month from gebdat) ;' ;

query1.SQL.Clear;
query1.sql.Add(strquery);
query1.Active := true;
query1.First;
while Not Query1.Eof do
  begin
  Listbox4.Items.Add(query1['Name']);
  query1.Next;
  end;

warum nicht:
strquery:='select * from adressen where extract(month from gebdat)='+MonthOf(now)+' order by debdat';