|
Posted by @sh on 09/13/06 12:39
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]
|