Re: [DUG] (interbase) extract(month from datefield)

[Paul McKenzie]

I think from memory you have to do this as a sub-select...   HTH   Regards Paul McKenzie SMSS Ltd. Wellington New Zealand ----- Original Message ----- From: tracey To: NZ Borland Developers Group - Delphi List Sent: Tuesday, August 10, 2004 3:42 PM Subject: [DUG] (interbase) extract(month from datefield) Could someone tell me what is wrong with this query please??   select h.shortnotes, h.notificationdate, max(hr.datereviewed) from hazard h left join hazardreview hr on h.hazardid = hr.hazardid where h.companyid = 9 and (extract(month from hr.datereviewed) = 7) group by h.notificationdate, h.shortnotes   I get an error: _expression_ evaluation not supported _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi