sveint wrote:

> Hello,
>
> I am concerned as similiar queries, only changing the way I specify the
> dates, give different results.
>
> Query A would use EXTRACT, example:
> EXTRACT(month FROM accountingdate)=' . $currentmonth . '
>
> Query B would use <>=, example:
> accountingdate>=' . $begindate . '
>
> Now the odd thing is that I get different results, for a sum of sales
> figures. A quick check of the actual sales summed up outside of the
> database reveals that Query B gives the correct answer.
>
> Now this is a major concern as I just Query A type syntax in some other
> reports. Why doesn't it work correctly? Any links to more information
> about extract? The manual information suggests that Query A should be
> synonymous with Query B.
>
> Thanks for any information
>
forgot to also mention that should you choose to use QueryB - I would also
include "AND accountingdate<' . $enddate . '" Make sure you know the exact
timeframe you are looking for.

--
Michael Austin.
DBA Consultant
Donations welcomed. Http://www.firstdbasource.com/donations.html