SQL query error

Support and Discussion Database Server
1

Hi,

–
– Table structure for table Purchase_Master

CREATE TABLE Purchase_Master (
PMID int(11) NOT NULL,
Vendor varchar(255) NOT NULL,
UID int(11) NOT NULL,
PID int(11) NOT NULL,
MUID int(11) NOT NULL,
PQuantity float NOT NULL,
Amount float NOT NULL,
PurchasedAt date NOT NULL DEFAULT current_timestamp(),
BitStatus int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1

#1067 - Invalid default value for ‘PurchasedAt’

What needs to be done? Tried but while importing database, getting error.