How to search month wise data from sqlserver
Hi Friends,How to search month wise data from Sql Server:
In DB data is in the form of dd-mm-yy (ex: 05-10-1989)
I need to get the data based on month , My problem is datatype is nvarchar(50), I can't able to get the date based on month directly.
Thanks in Advance,
Thanks,
Naseer