|
|
Posted by @sh on 09/13/06 11:30
An update actually, based on the SQL you suggested I am getting all records
returned, with no filter - including dates from 2003, 2004 etc?
SELECT *
FROM sol_session
SELECT *
FROM SOL_Session
WHERE DateGiven >= '10/09/06' AND DateGiven
<= '13/09/06'
Any ideas?
Cheers, @sh
"@sh" <spam@spam.com> wrote in message news:O9WdnXNmTY_5d5rYRVnyug@bt.com...
> Ahhhhh sorry for being silly, knew it'd be something obvious, not having a
> good week!!!
>
> Is it possible to use BETWEEN for such a SQL statement?
>
> Cheers, @sh
>
>
> "Roy Harvey" <roy_harvey@snet.net> wrote in message
> news:eipfg21v7lgkd3nk8fg5ulg1jfou2ah43l@4ax.com...
>> On Wed, 13 Sep 2006 11:59:46 +0100, "@sh" <spam@spam.com> wrote:
>>
>>> WHERE DateGiven > '10/09/2006' AND <
>>>'13/09/2006'
>>
>> WHERE DateGiven > '10/09/2006'
>> AND DateGiven < '13/09/2006'
>>
>> You need to specify DateGiven for each comparison.
>>
>> Roy Harvey
>> Beacon Falls, CT
>
>
Navigation:
[Reply to this message]
|