Posted by @sh on 09/13/06 11:33

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
>
>

• Next in forum: Re: Best practice for storing long text fields
• Prev in forum: Re: SQL Between Dates
• Thread view: Re: SQL Between Dates

[Reply to this message]