sql get month & year from date



 SELECT   
 OTDate as Date  
 ,CONVERT(CHAR(4), OTDate, 100) as Month   
 ,CONVERT(CHAR(4), OTDate, 120)as Year  
 FROM Payroll_tblEmployeeOTHour  

Popular posts from this blog

mvc razor textboxfor change event change another textboxfor value

WPF Crystal Report Viewer Using SAP

ASP.NET MVC razor SAP Crystal report