Need to get month and year from date [Resolved]

Posted by Sriharim under Sql Server on 5/6/2015 | Points: 10 | Views : 1448 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Need to get month and year from Date column


select convert(varchar(10),convert(varchar(20),convert(varchar(4),datename(month, HireDate))+' ' +convert(varchar(4), 
year(HireDate)),103)) 
from employee

in below format (month/year)
09/2015

Mark as Answer if its helpful to you
---
Srihari

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 5/6/2015 [Member] [MVP] Platinum | Points: 50

0	select RIGHT(CONVERT(VARCHAR(10), HireDate, 103), 7) AS [MM/YYYY] from employee Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Sriharim, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sriharim on: 5/6/2015 [Member] Starter | Points: 25

0	Also, please help me to resolve http://www.dotnetfunda.com/forums/show/19671/csharp-script-in-ssis-script-component-to-insert-data Mark as Answer if its helpful to you --- Srihari Sriharim, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Amatya on: 5/9/2015 [Member] Silver | Points: 25

0	select RIGHT(CONVERT(VARCHAR(10), HireDate, 103), 7) AS [MM/YYYY] from employee Feel free to share informations. mail Id ' adityagupta200@gmail.com Thanks Sriharim, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts