Error in Update Command

Question

Hi

MySqlCommand =

I am using MySql database.

Thanks

myCommand = new MySqlCommand("update hs_hr_attendance set punchout_time = " + "SubTime(Now(), '03:30:00')" + " where DATE_FORMAT(punchin_time,'%d/%m/%Y') = '" + _dt.ToString("dd/MM/yyyy") + "' and employee_id = " + empno + ")", con);