extracting year from date field?

[viveleroi]

If I have a query like:

SELECT * FROM someTable

and in the table I have a Date field (with Date format of course), how can I pull any record with a date in the year 2004?

The field in is MM/DD/YYYY format, how do I just get the YYYY out, and check to see if:

SELECT * FROM someTable WHERE dateField = 2004

 

[ByteMyzer]

Try:

SELECT * FROM someTable WHERE Year(dateField) = 2004;