tenriquez199
asked on
Make an SQL query for the termination of a field??
Hi,
I have a date in a just one field like this 11/May/2011
but i need make a query that get all of 2011
something like this
..... where date = '...../2011'
I have a date in a just one field like this 11/May/2011
but i need make a query that get all of 2011
something like this
..... where date = '...../2011'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
where date >= '20110101' and date < '20120101'