Sqlx, what is the correct decoder to use for a timestamp?

help
1

What's the correct decoder to use for a column type postgresql "TIMESTAMP"?

i'm trying to follow the types from sqlx::postgres::types - Rust

using chrono feature

row.get::<chrono::DateTime<chrono::Utc>>("created_at");
// E0277: the trait bound `chrono::DateTime<Utc>: Type<Postgres>` is not satisfied

same for .

Using the "time" feature types, it complains that i need more generics but the manual doesn't mention that signatures:

get::<sqlx::types::time::OffsetDateTime>.get("created_at");
// E0107: supplied 1 generic (expects 2?)

same for primitiveDateTime, etc.

2

banging my head against it, i can just tell the compiler to guess the second generic: get::<sqlx::types::time::PrimitiveDateTime, _>("created_at") and I end up with a variable of type PrimitiveDateTime... but none the wiser about it.