How do I get rid of error #1064 Table structure for table tbl_appointment

CREATE TABLE IF NOT EXISTS `tbl_appointment` (
`ap_id` int( 11 ) NOT NULL ,
`ap_starting` time( 6 ) NOT NULL ,
`ap_ending` time( 6 ) NOT NULL ,
`ap_day` varchar( 255 ) NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = latin1;


MySQL said: Documentation


  1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL,
    ap_ending time(6) NOT NULL,
    ap_day varchar(255) NOT NULL
  )' at line 9`


I tried to import the SQL file to phpmyadmin. the file works fine on later version of XAMPP from what I have. I tried to edit the SQL file based on the error but to no avail.
The microsecond fractional part of your DDL (I.e. The (6)) is only supported from MySQL 5.6 onward. Most likely a compatibility issue I'm afraid.