Sunday, December 15, 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  

vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link. http://www.microsoft.com/download...