Pomelo.EntityFrameworkCore.MySql: Invalid default value with CLR type DateTime

Hi there

Sorry if this is another silly question.

I have the following model

public class TankLevel{
    public int id { get; set; }
    public DateTime dateLogged { get; set; } = DateTime.Now;
    public int level { get; set; }
}

and the following in my OnModelCreating

modelBuilder.Entity<TankLevel>()
     .Property(l => l.dateLogged)
     .HasDefaultValueSql("CURRENT_TIMESTAMP");

Unfortunately, when I try to update the database, I get the error Invalid default for dateLogged.

Am I doing something silly?

Thanks in advance

Stuart