|
|
Posted by @sh on 09/13/06 12:14
Thanks for your reply Roy, yes DateGiven is a datetime field type, hence the
reason I'm confused as to this not working? Is there any other reason that
I'd get 2003/2004/2005 dates listed? Is there a way that I can force SQL to
read the DateGiven field as a Date subtype? And perhaps force the input
dates to datetime format too?
Cheers, @sh
"Roy Harvey" <roy_harvey@snet.net> wrote in message
news:2frfg253eetd9cq4ben5b4vscvbjbtteu9@4ax.com...
> Is DateGiven a datetime datatype? It sounds like it is a string, and
> of course string comparison is from left to right, character by
> character.
>
> If you must store dates as strings - datetime is much better - the
> safest way is yyyymmdd format. That is also the preferred format for
> giving any date string to SQL Server as it avoids all the confusion of
> October 9 vs September 10 that occurs when working internationally.
>
> Roy Harvey
> Beacon Falls, CT
>
> On Wed, 13 Sep 2006 12:30:26 +0100, "@sh" <spam@spam.com> wrote:
>
>>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]
|