Struct diesel::sql_types::Timestamptz

pub struct Timestamptz;

Available on crate feature postgres_backend only.

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, 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<'expr2, 'expr, 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<'expr2, 'expr> 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<'expr2, 'expr> 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<'expr2, 'expr> 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<'expr2, 'expr> 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<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

Available on crate feature postgres only.

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.

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

Performs copy-assignment from source.

impl Debug for Timestamptz

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

Formats the value using the given formatter.

impl Default for Timestamptz

fn default() -> Timestamptz

Returns the “default value” for a type.

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<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

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<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

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<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

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<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamptz, Pg> for PgTimestamp

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

See the trait documentation.

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

A specialized variant of from_sql for handling null values.

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<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl HasSqlType<Timestamptz> for Pg

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

Fetch the metadata for the given type

impl QueryId for Timestamptz

type QueryId = Timestamptz

A type which uniquely represents Self in a SQL query.

const HAS_STATIC_QUERY_ID: bool = true

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

fn query_id() -> Option<TypeId>

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

impl SqlType for Timestamptz

type IsNull = NotNull

Is this type nullable?

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

Available on crate feature postgres only.