Struct Interval

pub struct Interval;

The interval SQL type.

This type is currently only implemented for PostgreSQL.

ToSql impls

• PgInterval which can be constructed using IntervalDsl
• chrono::Duration with feature = "chrono"

FromSql impls

• PgInterval which can be constructed using IntervalDsl
• chrono::Duration with feature = "chrono" (There might be some information loss due to special behavior for literal month (or longer) intervals; Please read official documentation of PostgreSQL Interval.)

Trait Implementations

impl Add for Interval

type Rhs = Interval

The SQL type which can be added to this one

type Output = Interval

The SQL type of the result of adding Rhs to Self

impl<'__expr, '__expr2> AsExpression<Interval> for &'__expr2 &'__expr PgInterval

Available on crate feature postgres_backend only.

type Expression = Bound<Interval, &'__expr2 &'__expr PgInterval>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Interval>>::Expression

Perform the conversion

impl<'__expr, '__expr2> AsExpression<Interval> for &'__expr2 &'__expr Duration

Available on crate feature chrono only.

type Expression = Bound<Interval, &'__expr2 &'__expr TimeDelta>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Interval>>::Expression

Perform the conversion

impl<'__expr> AsExpression<Interval> for &'__expr PgInterval

Available on crate feature postgres_backend only.

type Expression = Bound<Interval, &'__expr PgInterval>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Interval>>::Expression

Perform the conversion

impl<'__expr> AsExpression<Interval> for &'__expr Duration

Available on crate feature chrono only.

type Expression = Bound<Interval, &'__expr TimeDelta>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Interval>>::Expression

Perform the conversion

impl AsExpression<Interval> for PgInterval

Available on crate feature postgres_backend only.

type Expression = Bound<Interval, PgInterval>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Interval>>::Expression

Perform the conversion

impl AsExpression<Interval> for Duration

Available on crate feature chrono only.

type Expression = Bound<Interval, TimeDelta>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Interval>>::Expression

Perform the conversion

impl Clone for Interval

fn clone(&self) -> Interval

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Interval

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

Formats the value using the given formatter.

impl Default for Interval

fn default() -> Interval

Returns the “default value” for a type.

impl Div for Interval

type Rhs = Integer

The SQL type which this one can be divided by

type Output = Interval

The SQL type of the result of dividing Self by Rhs

impl Foldable for Interval

type Sum = Nullable<Interval>

The SQL type of sum(this_type)

type Avg = Nullable<Interval>

The SQL type of avg(this_type)

impl FromSql<Interval, Pg> for PgInterval

Available on crate feature postgres_backend only.

fn from_sql(value: 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.

impl FromSql<Interval, Pg> for Duration

Available on crate features chrono and postgres_backend 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.

impl HasSqlType<Interval> for Pg

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

Fetch the metadata for the given type

impl KnownCastSqlTypeName<Pg> for Interval

Available on crate feature postgres_backend only.

const SQL_TYPE_NAME: &'static str = "interval"

What to write as sql_type in the CAST(expr AS sql_type) SQL for Self

impl Mul for Interval

type Rhs = Integer

The SQL type which this can be multiplied by

type Output = Interval

The SQL type of the result of multiplying Self by Rhs

impl QueryId for Interval

const HAS_STATIC_QUERY_ID: bool = true

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

type QueryId = Interval

A type which uniquely represents Self in a SQL query.

fn query_id() -> Option<TypeId>

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

impl SqlType for Interval

type IsNull = NotNull

Is this type nullable?

impl Sub for Interval

type Rhs = Interval

The SQL type which can be subtracted from this one

type Output = Interval

The SQL type of the result of subtracting Rhs from Self

impl ToSql<Interval, Pg> for PgInterval

Available on crate feature postgres_backend only.

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

See the trait documentation.

impl ToSql<Interval, Pg> for Duration

Available on crate features chrono and postgres_backend only.

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

See the trait documentation.

impl Copy for Interval

impl SingleValue for Interval

impl SqlOrd for Interval