SQL statement for specific month

[usin]

hello,

is there any way to retrieve for records that the datefield match only the specific month of a year.

for example:
if I want to retrieve the expenses record that occur in the month of january.

really need your help.

best regard usin.

[czimmerman]

In SQL Server,

SELECT * FROM MYTABLE WHERE DATEPART(mm, MYDATEFIELD) = 01

[usin]

thank you very much.

i have rated you excellent.


usin.

[Iouri]

Also you can use
select * from table where Month(YourDate) = 05

Iouri Boutchkine
iouri@hotsheet.com