diesel::pg::sql_types

Struct Timestamptz

pub struct Timestamptz;

Available on crate feature postgres_backend only.

Expand description

The “timestamp with time zone” SQL type, which PostgreSQL abbreviates to timestamptz.

§`ToSql` impls

PgTimestamp
chrono::NaiveDateTime with feature = "chrono"
chrono::DateTime with feature = "chrono"
time::PrimitiveDateTime with feature = "time"
time::OffsetDateTime with feature = "time"

§`FromSql` impls

PgTimestamp
chrono::NaiveDateTime with feature = "chrono"
chrono::DateTime with feature = "chrono"
time::PrimitiveDateTime with feature = "time"
time::OffsetDateTime with feature = "time"

Trait Implementations§

impl Add for Timestamptz

type Rhs = Interval

The SQL type which can be added to this one

type Output = Timestamptz

The SQL type of the result of adding Rhs to Self

impl<'expr, 'expr2, Tz: TimeZone> AsExpression<Timestamptz> for &'expr2 &'expr DateTime<Tz>

Available on crate feature chrono only.

type Expression = Bound<Timestamptz, &'expr2 &'expr DateTime<Tz>>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr, 'expr2> AsExpression<Timestamptz> for &'expr2 &'expr NaiveDateTime

Available on crate feature chrono only.

type Expression = Bound<Timestamptz, &'expr2 &'expr NaiveDateTime>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr, 'expr2> AsExpression<Timestamptz> for &'expr2 &'expr OffsetDateTime

Available on crate feature time only.

type Expression = Bound<Timestamptz, &'expr2 &'expr OffsetDateTime>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr, 'expr2> AsExpression<Timestamptz> for &'expr2 &'expr PgTimestamp

type Expression = Bound<Timestamptz, &'expr2 &'expr PgTimestamp>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr, 'expr2> AsExpression<Timestamptz> for &'expr2 &'expr PrimitiveDateTime

Available on crate feature time only.

type Expression = Bound<Timestamptz, &'expr2 &'expr PrimitiveDateTime>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr, Tz: TimeZone> AsExpression<Timestamptz> for &'expr DateTime<Tz>

Available on crate feature chrono only.

type Expression = Bound<Timestamptz, &'__expr DateTime<Tz>>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr> AsExpression<Timestamptz> for &'expr NaiveDateTime

Available on crate feature chrono only.

type Expression = Bound<Timestamptz, &'__expr NaiveDateTime>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr> AsExpression<Timestamptz> for &'expr OffsetDateTime

Available on crate feature time only.

type Expression = Bound<Timestamptz, &'__expr OffsetDateTime>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr> AsExpression<Timestamptz> for &'expr PgTimestamp

type Expression = Bound<Timestamptz, &'__expr PgTimestamp>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<'expr> AsExpression<Timestamptz> for &'expr PrimitiveDateTime

Available on crate feature time only.

type Expression = Bound<Timestamptz, &'__expr PrimitiveDateTime>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl<Tz: TimeZone> AsExpression<Timestamptz> for DateTime<Tz>

Available on crate feature chrono only.

type Expression = Bound<Timestamptz, DateTime<Tz>>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl AsExpression<Timestamptz> for NaiveDateTime

Available on crate feature chrono only.

type Expression = Bound<Timestamptz, NaiveDateTime>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl AsExpression<Timestamptz> for OffsetDateTime

Available on crate feature time only.

type Expression = Bound<Timestamptz, OffsetDateTime>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl AsExpression<Timestamptz> for PgTimestamp

type Expression = Bound<Timestamptz, PgTimestamp>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl AsExpression<Timestamptz> for PrimitiveDateTime

Available on crate feature time only.

type Expression = Bound<Timestamptz, PrimitiveDateTime>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl AsExpression<Timestamptz> for now

type Expression = Coerce<now, Timestamptz>

The expression being returned

fn as_expression(self) -> Self::Expression

Perform the conversion

impl Clone for Timestamptz

fn clone(&self) -> Timestamptz

Returns a copy of the value. Read more

1.0.0 · Source§

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source. Read more

impl Debug for Timestamptz

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more

impl Default for Timestamptz

fn default() -> Timestamptz

Returns the “default value” for a type. Read more

impl FromSql<Timestamptz, Pg> for DateTime<Local>

Available on crate feature chrono only.

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values. Read more

impl FromSql<Timestamptz, Pg> for DateTime<Utc>

Available on crate feature chrono only.

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values. Read more

impl FromSql<Timestamptz, Pg> for NaiveDateTime

Available on crate feature chrono only.

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values. Read more

impl FromSql<Timestamptz, Pg> for OffsetDateTime

Available on crate feature time only.

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values. Read more

impl FromSql<Timestamptz, Pg> for PgTimestamp

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values. Read more

impl FromSql<Timestamptz, Pg> for PrimitiveDateTime

Available on crate feature time only.

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values. Read more

impl HasSqlType<Timestamptz> for Pg

fn metadata(_: &mut Self::MetadataLookup) -> PgTypeMetadata

Fetch the metadata for the given type Read more

impl QueryId for Timestamptz

const HAS_STATIC_QUERY_ID: bool = true

Can the SQL generated by Self be uniquely identified by its type? Read more

type QueryId = Timestamptz

A type which uniquely represents Self in a SQL query. Read more

fn query_id() -> Option<TypeId>

Returns the type id of Self::QueryId if Self::HAS_STATIC_QUERY_ID. Returns None otherwise. Read more

impl SqlType for Timestamptz

type IsNull = NotNull

Is this type nullable? Read more

impl Sub for Timestamptz

type Rhs = Interval

The SQL type which can be subtracted from this one

type Output = Timestamptz

The SQL type of the result of subtracting Rhs from Self

impl<TZ: TimeZone> ToSql<Timestamptz, Pg> for DateTime<TZ>

Available on crate feature chrono only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

See the trait documentation.

impl ToSql<Timestamptz, Pg> for NaiveDateTime

Available on crate feature chrono only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

See the trait documentation.

impl ToSql<Timestamptz, Pg> for OffsetDateTime

Available on crate feature time only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

See the trait documentation.

impl ToSql<Timestamptz, Pg> for PgTimestamp

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

See the trait documentation.

impl ToSql<Timestamptz, Pg> for PrimitiveDateTime

Available on crate feature time only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

See the trait documentation.

impl Copy for Timestamptz

impl SingleValue for Timestamptz

impl SqlOrd for Timestamptz

Auto Trait Implementations§

impl Freeze for Timestamptz

impl RefUnwindSafe for Timestamptz

impl Send for Timestamptz

impl Sync for Timestamptz

impl Unpin for Timestamptz

impl UnwindSafe for Timestamptz

Blanket Implementations§

impl<T> Any for T
where T: 'static + ?Sized,

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more

impl<T> Borrow<T> for T
where T: ?Sized,

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more

impl<T> BorrowMut<T> for T
where T: ?Sized,

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more

impl<T> CloneToUninit for T
where T: Clone,

unsafe fn clone_to_uninit(&self, dst: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)

Performs copy-assignment from self to dst. Read more

impl<ST, U, DB> CompatibleType<U, DB> for ST
where DB: Backend, ST: SqlType + SingleValue, U: FromSqlRow<ST, DB>,

type SqlType = ST

Available on crate feature i-implement-a-third-party-backend-and-opt-into-breaking-changes only.

impl<T> Downcast for T
where T: Any,

fn into_any(self: Box<T>) -> Box<dyn Any>

Convert Box<dyn Trait> (where Trait: Downcast) to Box<dyn Any>. Box<dyn Any> can then be further downcast into Box<ConcreteType> where ConcreteType implements Trait.

fn into_any_rc(self: Rc<T>) -> Rc<dyn Any>

Convert Rc<Trait> (where Trait: Downcast) to Rc<Any>. Rc<Any> can then be further downcast into Rc<ConcreteType> where ConcreteType implements Trait.

fn as_any(&self) -> &(dyn Any + 'static)

Convert &Trait (where Trait: Downcast) to &Any. This is needed since Rust cannot generate &Any’s vtable from &Trait’s.

fn as_any_mut(&mut self) -> &mut (dyn Any + 'static)

Convert &mut Trait (where Trait: Downcast) to &Any. This is needed since Rust cannot generate &mut Any’s vtable from &mut Trait’s.

impl<T> DowncastSync for T
where T: Any + Send + Sync,

fn into_any_arc(self: Arc<T>) -> Arc<dyn Any + Send + Sync>

Convert Arc<Trait> (where Trait: Downcast) to Arc<Any>. Arc<Any> can then be further downcast into Arc<ConcreteType> where ConcreteType implements Trait.

impl<T> From<T> for T

fn from(t: T) -> T

Returns the argument unchanged.

impl<T, U> Into<U> for T
where U: From<T>,

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

impl<T> IntoNotNullable for T
where T: SqlType<IsNull = NotNull>,

type NotNullable = T

The not nullable representation of this type. Read more

impl<T> IntoNullable for T
where T: SqlType<IsNull = NotNull> + SingleValue,

type Nullable = Nullable<T>

The nullable representation of this type. Read more

impl<T> IntoSql for T

fn into_sql<T>(self) -> AsExprOf<Self, T>
where Self: AsExpression<T> + Sized, T: SqlType + TypedExpressionType,

Convert self to an expression for Diesel’s query builder. Read more

fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T>
where &'a Self: AsExpression<T>, T: SqlType + TypedExpressionType,

Convert &self to an expression for Diesel’s query builder. Read more

impl<T> ToOwned for T
where T: Clone,

type Owned = T

The resulting type after obtaining ownership.

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more

impl<T, U> TryFrom<U> for T
where U: Into<T>,

type Error = Infallible

The type returned in the event of a conversion error.

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

Performs the conversion.

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.

impl<V, T> VZip<V> for T
where V: MultiLane<T>,

fn vzip(self) -> V

impl<T> ErasedDestructor for T
where T: 'static,

impl<T> MaybeSendSync for T

impl<ST> TypedExpressionType for ST
where ST: SingleValue,