how can I use Timestamp in diesel

[xu756]

schema.rs

// @generated automatically by Diesel CLI.

diesel::table! {
    user (id) {
        id -> Int8,
        created_at -> Timestamp,
        updated_at -> Timestamp,
        wx_openid -> Varchar,
        editor -> Int8,
        nick_name -> Varchar,
        password -> Varchar,
        mobile -> Varchar,
        avatar -> Bytea,
        desc -> Text,
    }
}

when I definition User Table

use diesel::{prelude::*, sql_types::{Bytea, Timestamp}};
use chrono::NaiveDateTime;


#[derive(Queryable, Selectable)]
#[diesel(table_name = super::schema::user)]
#[diesel(check_for_backend(diesel::pg::Pg))]
pub struct User {
    pub id: i64,
    pub created_at: Timestamp,
    // pub updated_at: Timestamp,
    pub updated_at: NaiveDateTime,
    pub wx_openid: String,
    pub editor: i64,
    pub nick_name: Bytea,
    pub password: String,
    pub mobile: String,
    pub avatar: Vec<u8>,
    pub desc: String,
}

this is error

the trait bound `diesel::sql_types::Timestamp: FromSqlRow<diesel::sql_types::Timestamp, Pg>` is not satisfied
double check your type mappings via the documentation of `diesel::sql_types::Timestamp`
`diesel::sql_query` requires the loading target to column names for loading values.
You need to provide a type that explicitly derives `diesel::deserialize::QueryableByName`
the following other types implement trait `FromSqlRow<ST, DB>`:
  <(T1, T0) as FromSqlRow<(ST1, Untyped), __DB>>
  <(T1, T2, T0) as FromSqlRow<(ST1, ST2, Untyped), __DB>>
  <(T1, T2, T3, T0) as FromSqlRow<(ST1, ST2, ST3, Untyped), __DB>>
  <(T1, T2, T3, T4, T0) as FromSqlRow<(ST1, ST2, ST3, ST4, Untyped), __DB>>
  <(T1, T2, T3, T4, T5, T0) as FromSqlRow<(ST1, ST2, ST3, ST4, ST5, Untyped), __DB>>
  <(T1, T2, T3, T4, T5, T6, T0) as FromSqlRow<(ST1, ST2, ST3, ST4, ST5, ST6, Untyped), __DB>>
  <(T1, T2, T3, T4, T5, T6, T7, T0) as FromSqlRow<(ST1, ST2, ST3, ST4, ST5, ST6, ST7, Untyped), __DB>>
  <(T1, T2, T3, T4, T5, T6, T7, T8, T0) as FromSqlRow<(ST1, ST2, ST3, ST4, ST5, ST6, ST7, ST8, Untyped), __DB>>
and 23 others
required for `diesel::sql_types::Timestamp` to implement `FromSqlRow<diesel::sql_types::Timestamp, Pg>`

how can I do it

[weiznich]

This is an incomplete error message, checkout the full error message emitted by the compiler. It will contain more details.

That said, even this part already contains the following note:

double check your type mappings via the documentation of diesel::sql_types::Timestamp

The problem here is that diesel::sql_types::Timestamp cannot hold values at all as written in the crate documentation:

Diesel maps “Rust types” (e.g. i32) to and from “SQL types” (e.g. diesel::sql_types::Integer). You can find all the types supported by Diesel in the sql_types module. These types are only used to represent a SQL type. You should never put them on your Queryable structs.

Source