Selecting Records using a part of a date 1

[da644]

Hi Everyone.

I have a table with a date field and I would like to extract all records with a date with a certain month or year. One way I thought of doing this was:

select fieldnames
from tablename
where datefield >= '2003/10/01'
and datefield <= '2003/10/31'

and something similar for the year, however this for some reason seems very inefficient (maybe its not), but is there a better way?

Thanks

Best Regards

Andrew.

 

[r937]

it is actually very efficient

it allows an index on the datefield to be used

you do have an index, right?


rudy

http://r937.com/

 

[da644]

Hi

Yeah, I did think of it like that. It just didn't look good when I coded it.

Thanks

Best Regards

Andrew.

 

[KarveR]

if you dont like typing you can use :
select fieldnames
from tablename
where datefield like '2003/10/__'


______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[da644]

The doesn't seem to work. is the __ part two underscores?

 

[KarveR]

yes , each _ (underscore) represents a single character, for multiple characters use % or the correct number of _.




______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.