|
|
Posted by Roy Harvey on 09/13/06 12:51
I don't know. An example that fails tells us a lot more than one that
works. The question is, can you reproduce the failures?
One thought came to mind just now. A mistake in typing in the date
string resulted in a string that could not be converted to a datetime
would cause the sort of problem under discussion.
Roy
On Wed, 13 Sep 2006 13:42:17 +0100, "@sh" <spam@spam.com> wrote:
>Hang on......this query now works fine...what has changed or am I being
>silly?
>
>SELECT *
>FROM sol_session
>WHERE (DateGiven >= '10/09/2006') AND (DateGiven <= '12/09/2006')
>ORDER BY dategiven DESC
>
>Is it the brackets?
>
>Cheers, @sh
Navigation:
[Reply to this message]
|