Skip to main content

Posts

Showing posts from December, 2013

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