Query Builder using LastMonth condition is returning incorrect results (4310458)

Connected to a SQL Server 2005 database, when running a Query Builder query with a condition of /*lastmonth*/ the results are returning the first day of the current month. e.g. expected to see results up to the 28th February, but results for 1st March were also included

SQL Server precision issue. The actual query fired off by Toad when /*lastmonth*/ is selected sets the betwween date to be the following:

BETWEEN '2010-02-01 00:00:00' AND '2010-02-28 23:59:59.999')

Anything over 23:59:59.998 will be rounded up to 12:00:00:0000

Â

Â

WORKAROUND

none

STATUS

Waiting for fix in a future release of Toad for Data Analysts