how do I return anything in year 2005

[DougP]

Select * From myTable where SomeDate = '%/%/2005'

DougP, MCP, A+

 

[cLFlaVA]

select *
  from myTable
 where year( SomeDate ) = 2005

*cLFlaVA
----------------------------
[tt]( <P> <B>)[sup]13[/sup] * (<P> <.</B>)[/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[jbenson001]

Select * from myTable
Where right(convert(varchar(10),somedate,101),4) = '2005'

Jim

 

[bla1979]

Another Way...

Select DATENAME(yy ,somedate) as 'Somedate'
from mytable
Where DATENAME(yy ,somedate) = '2005'

 

[gmmastros]

I would have done this the same way the cLFlaVA shows. But since we're getting in to multiple ways...

Select * From myTable where SomeDate Like '%2005%'

The problem with this method is that there will be an implicit data type conversion (from DateTime to varchar) so that the like comparison can work.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

If you don't want index or table scans then do this

SELECT * FROM myTable 
WHERE SomeDate >='20050101'
AND  SomeDate < '20060101'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[DougP]

Thank you all

DougP, MCP, A+