Mysql8.0 Trying to insert a DateTimeUtc value in timestamp an error

[doveq]

Hi all,

Mysql table like:

CREATE TABLE `test` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `creation_time` timestamp NOT NULL DEFAULT '1970-01-01 00:00:01', 
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

SeaOrm model:

#[serde_as]
#[derive(Clone, Debug, PartialEq, Serialize, Deserialize, DeriveEntityModel)]
#[sea_orm(table_name = "test")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: i64,
    #[sea_orm(column_type = "Timestamp")]
    pub creation_time: DateTimeUtc,
}

insert error:
Error Code: 1292. Incorrect datetime value: '2024-04-24 16:00:00 +00:00' for column 'creation_time' at row 1
Any idea what I'm doing wrong here?

[tyt2y3]

The error code probably should point it out, but timestamps in MySQL has no timezone.

[doveq]

maybe a problem with the time crate, replaced it with chrono is ok.