How to search month wise data from Sql Server [Resolved]

Posted by Naseer under Sql Server on 8/28/2016 | Points: 10 | Views : 1339 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rajnilari2015 on: 8/28/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

0	Try this to get month declare @dt as nvarchar(50) = '05-10-1989' select [Month] = parsename(replace(@dt,'-','.'),2) output --------- Month 10 Now I hope you can proceed. Thanks. -- Thanks & Regards, RNA Team Naseer, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts