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.
Printable View
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.
In SQL Server,
SELECT * FROM MYTABLE WHERE DATEPART(mm, MYDATEFIELD) = 01
thank you very much.
i have rated you excellent.
usin.
Also you can use
select * from table where Month(YourDate) = 05
Iouri Boutchkine
[email protected]