Friday, December 27, 2013

Sunday, December 15, 2013

sql get month & year from date

 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.