Can you confirm that the datatype of the column is datetime and not timestamp in DB? The smallest datetime value is 1000-01-01 and timestamp value is 1970-01-01 in MySQL. See DateTime Storage for more ...

So say you have a Schema Employees DateofBirth (Date) (Encrypted ENCRYPTION_TYPE = DETERMINISTIC) ModifiedUtc (DateTime2) When you go to do an insert against Employees, you will get; Tesco.HRAM.Tes ...