|
|
Posted by @sh on 09/13/06 12:42
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
"@sh" <spam@spam.com> wrote in message news:bd6dnYXCzp5sZprYRVny3g@bt.com...
> Interestingly, the following SQL works perfectly as well...
>
> SELECT *
> FROM sol_session sol_session_1
> WHERE (DateGiven = '13/09/2006')
>
> But change the = to a > and it doesn't give me any results!?
>
> Cheers, @sh
>
>
> "@sh" <spam@spam.com> wrote in message
> news:usCdnVsa9K1cZJrYRVnyhg@bt.com...
>> Thanks again for your help here!!
>>
>>> SELECT *
>>> FROM SOL_Session
>>> WHERE DateGiven >= '10 Sep 2006'
>>> AND DateGiven <= '13 Sep 2006'
>>
>> I get a listing of CORRECT results ;o)
>>
>>
>>> SELECT *
>>> FROM SOL_Session
>>> WHERE DateGiven >= '20060910'
>>> AND DateGiven <= '20060913'
>>
>> Another list of correct results - are these good or bad findings?
>>
>> Cheers, @sh
>>
>
>
Navigation:
[Reply to this message]
|