I want to select multiple records on the basis of a matching year, for example in table tab
where columns are [id] int
, [name] varchar
, [bookyear] datetime
I want to select all records where the year is 2009.
The following query gives 0 results:
SELECT [ACCNO] ,[Roll No] ,[IssueDate] ,[DueDate] FROM [test1].[dbo].[IssueHis$] where [IssueDate] between 12-12-2004 and 1-01-2010
Advertisement
Answer
select id,name,bookyear from tab1 where year(bookyear) = 2009