While running queries with data type parameters in Toad for Oracle 9.7 consecutively the month and day values are swapped.
Waiting for fix in a future release of Toad for Oracle.
When date type parameters is set to '2008-04-01'
In second go it becomes : 2008-01-04
In third go it becomes : 2008-04-01 and so on