Wednesday, April 16, 2014

SQL datetime to AM/PM

just set you datefield in
Payroll_tblAttendance.InTime

Finally:

 (SELECT RIGHT(LTRIM(RIGHT(CONVERT(varchar, Payroll_tblAttendance.InTime, 100),8)),8)) InTime,  

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...