Skip to main content

Date

diesel::sql_types

Struct Date

pub struct Date;

Expand description

The date SQL type.

§`ToSql` impls

chrono::NaiveDate with feature = "chrono"
time::Date with feature = "time"

§`FromSql` impls

chrono::NaiveDate with feature = "chrono"
time::Date with feature = "time"

Trait Implementations§

impl Add for Date

type Rhs = Interval

The SQL type which can be added to this one

type Output = Timestamp

The SQL type of the result of adding Rhs to Self

impl<'expr, 'expr2> AsExpression<Date> for &'expr2 &'expr NaiveDate

Available on crate feature time only.

type Expression = Bound<Date, &'expr2 &'expr Date>

The expression being returned

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

Perform the conversion

impl<'expr, 'expr2> AsExpression<Date> for &'expr2 &'expr MysqlTime

Available on crate feature mysql_backend only.

type Expression = Bound<Date, &'expr2 &'expr MysqlTime>

The expression being returned

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

Perform the conversion

impl<'expr, 'expr2> AsExpression<Date> for &'expr2 &'expr NaiveDate

Available on crate feature chrono only.

type Expression = Bound<Date, &'expr2 &'expr NaiveDate>

The expression being returned

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

Perform the conversion

impl<'expr, 'expr2> AsExpression<Date> for &'expr2 &'expr PgDate

Available on crate feature postgres_backend only.

type Expression = Bound<Date, &'expr2 &'expr PgDate>

The expression being returned

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

Perform the conversion

impl<'expr, 'expr2> AsExpression<Date> for &'expr2 &'expr String

type Expression = Bound<Date, &'expr2 &'expr String>

The expression being returned

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

Perform the conversion

impl<'expr, 'expr2> AsExpression<Date> for &'expr2 &'expr str

type Expression = Bound<Date, &'expr2 &'expr str>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Arc<NaiveDate>

Available on crate feature time only.

type Expression = Bound<Date, &'__expr Date>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Arc<NaiveDate>

Available on crate feature chrono only.

type Expression = Bound<Date, &'__expr NaiveDate>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Arc<String>

type Expression = Bound<Date, &'__expr String>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Arc<str>

type Expression = Bound<Date, &'__expr str>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Box<NaiveDate>

Available on crate feature time only.

type Expression = Bound<Date, &'__expr Date>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Box<NaiveDate>

Available on crate feature chrono only.

type Expression = Bound<Date, &'__expr NaiveDate>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Box<String>

type Expression = Bound<Date, &'__expr String>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Box<str>

type Expression = Bound<Date, &'__expr str>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr NaiveDate

Available on crate feature time only.

type Expression = Bound<Date, &'__expr Date>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr MysqlTime

Available on crate feature mysql_backend only.

type Expression = Bound<Date, &'__expr MysqlTime>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr NaiveDate

Available on crate feature chrono only.

type Expression = Bound<Date, &'__expr NaiveDate>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr PgDate

Available on crate feature postgres_backend only.

type Expression = Bound<Date, &'__expr PgDate>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Rc<NaiveDate>

Available on crate feature time only.

type Expression = Bound<Date, &'__expr Date>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Rc<NaiveDate>

Available on crate feature chrono only.

type Expression = Bound<Date, &'__expr NaiveDate>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Rc<String>

type Expression = Bound<Date, &'__expr String>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr Rc<str>

type Expression = Bound<Date, &'__expr str>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr String

type Expression = Bound<Date, &'__expr String>

The expression being returned

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

Perform the conversion

impl<'expr> AsExpression<Date> for &'expr str

type Expression = Bound<Date, &'__expr str>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Arc<NaiveDate>

Available on crate feature time only.

type Expression = Bound<Date, Arc<Date>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Arc<NaiveDate>

Available on crate feature chrono only.

type Expression = Bound<Date, Arc<NaiveDate>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Arc<String>

type Expression = Bound<Date, Arc<String>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Arc<str>

type Expression = Bound<Date, Arc<str>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Box<NaiveDate>

Available on crate feature time only.

type Expression = Bound<Date, Box<Date>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Box<NaiveDate>

Available on crate feature chrono only.

type Expression = Bound<Date, Box<NaiveDate>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Box<String>

type Expression = Bound<Date, Box<String>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Box<str>

type Expression = Bound<Date, Box<str>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for NaiveDate

Available on crate feature time only.

type Expression = Bound<Date, Date>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for MysqlTime

Available on crate feature mysql_backend only.

type Expression = Bound<Date, MysqlTime>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for NaiveDate

Available on crate feature chrono only.

type Expression = Bound<Date, NaiveDate>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for PgDate

Available on crate feature postgres_backend only.

type Expression = Bound<Date, PgDate>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Rc<NaiveDate>

Available on crate feature time only.

type Expression = Bound<Date, Rc<Date>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Rc<NaiveDate>

Available on crate feature chrono only.

type Expression = Bound<Date, Rc<NaiveDate>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Rc<String>

type Expression = Bound<Date, Rc<String>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for Rc<str>

type Expression = Bound<Date, Rc<str>>

The expression being returned

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

Perform the conversion

impl AsExpression<Date> for String

type Expression = Bound<Date, String>

The expression being returned

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

Perform the conversion

impl CastsTo<Text> for Date

impl Clone for Date

fn clone(&self) -> Date

Returns a duplicate of the value. Read more

1.0.0 (const: unstable) · Source§

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

Performs copy-assignment from source. Read more

impl Copy for Date

impl Debug for Date

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

Formats the value using the given formatter. Read more

impl Default for Date

fn default() -> Date

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

impl FallibleCastsTo<Date> for Text

impl FallibleCastsTo<Text> for Date

impl FromSql<Date, Mysql> for Date

Available on crate features mysql_backend and time only.

fn from_sql(bytes: MysqlValue<'_>) -> 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<Date, Mysql> for MysqlTime

Available on crate feature mysql_backend only.

fn from_sql(value: MysqlValue<'_>) -> 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<Date, Mysql> for NaiveDate

Available on crate features chrono and mysql_backend only.

fn from_sql(bytes: MysqlValue<'_>) -> 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<Date, Pg> for Date

Available on crate features postgres_backend and 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<Date, Pg> for NaiveDate

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. Read more

impl FromSql<Date, Pg> for PgDate

Available on crate feature 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. Read more

impl FromSql<Date, Sqlite> for Date

Available on crate features __sqlite-shared and time only.

fn from_sql(value: <Sqlite as Backend>::RawValue<'_>) -> 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<Date, Sqlite> for NaiveDate

Available on crate features __sqlite-shared and chrono only.

fn from_sql(value: <Sqlite as Backend>::RawValue<'_>) -> 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<Date, Sqlite> for String

Available on crate feature __sqlite-shared only.

fn from_sql(value: SqliteValue<'_, '_, '_>) -> 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<Date> for Mysql

fn metadata(_: &mut ()) -> MysqlType

Fetch the metadata for the given type Read more

impl HasSqlType<Date> for Pg

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

Fetch the metadata for the given type Read more

impl HasSqlType<Date> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type Read more

impl KnownCastSqlTypeName<Mysql> for Date

Available on crate feature mysql_backend only.

const SQL_TYPE_NAME: &'static str = "date"

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

impl KnownCastSqlTypeName<Pg> for Date

Available on crate feature postgres_backend only.

const SQL_TYPE_NAME: &'static str = "date"

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

impl QueryId for Date

const HAS_STATIC_QUERY_ID: bool = true

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

type QueryId = Date

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 SingleValue for Date

impl SqlOrd for Date

impl SqlType for Date

type IsNull = NotNull

Is this type nullable? Read more

impl Sub for Date

type Rhs = Interval

The SQL type which can be subtracted from this one

type Output = Timestamp

The SQL type of the result of subtracting Rhs from Self

impl ToSql<Date, Mysql> for Date

Available on crate features mysql_backend and time only.

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

See the trait documentation.

impl ToSql<Date, Mysql> for MysqlTime

Available on crate feature mysql_backend only.

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

See the trait documentation.

impl ToSql<Date, Mysql> for NaiveDate

Available on crate features chrono and mysql_backend only.

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

See the trait documentation.

impl ToSql<Date, Pg> for Date

Available on crate features postgres_backend and time only.

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

See the trait documentation.

impl ToSql<Date, Pg> for NaiveDate

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 ToSql<Date, Pg> for PgDate

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<Date, Sqlite> for Date

Available on crate features __sqlite-shared and time only.

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

See the trait documentation.

impl ToSql<Date, Sqlite> for NaiveDate

Available on crate features __sqlite-shared and chrono only.

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

See the trait documentation.

impl ToSql<Date, Sqlite> for String

Available on crate feature __sqlite-shared only.

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

See the trait documentation.

impl ToSql<Date, Sqlite> for str

Available on crate feature __sqlite-shared only.

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

See the trait documentation.

Auto Trait Implementations§

impl Freeze for Date

impl RefUnwindSafe for Date

impl Send for Date

impl Sync for Date

impl Unpin for Date

impl UnsafeUnpin for Date

impl UnwindSafe for Date

Blanket Implementations§

impl<T> AggregateExpressionMethods for T

fn aggregate_distinct(self) -> AggregateDistinct<Self>
where Self: DistinctDsl,

DISTINCT modifier for aggregate functions Read more

fn aggregate_all(self) -> AggregateAll<Self>
where Self: AllDsl,

ALL modifier for aggregate functions Read more

fn aggregate_filter<P>(self, f: P) -> AggregateFilter<Self, P>
where P: AsExpression<Bool>, Self: FilterDsl<P::Expression>,

Add an aggregate function filter Read more

fn aggregate_order<O>(self, o: O) -> AggregateOrder<Self, O>
where Self: OrderAggregateDsl<O>,

Add an aggregate function order Read more

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, dest: *mut u8)

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

Performs copy-assignment from self to dest. 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>

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

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

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

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

Converts &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)

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

impl<T> DowncastSend for T
where T: Any + Send,

fn into_any_send(self: Box<T>) -> Box<dyn Any + Send>

Converts Box<Trait> (where Trait: DowncastSend) to Box<dyn Any + Send>, which can then be downcast into Box<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<ST> TypedExpressionType for ST
where ST: SingleValue,

impl<T> WindowExpressionMethods for T

fn over(self) -> Over<Self>
where Self: OverDsl,

Turn a function call into a window function call Read more

fn window_filter<P>(self, f: P) -> WindowFilter<Self, P>
where P: AsExpression<Bool>, Self: FilterDsl<P::Expression>,

Add a filter to the current window function Read more

fn partition_by<E>(self, expr: E) -> PartitionBy<Self, E>
where Self: PartitionByDsl<E>,

Add a partition clause to the current window function Read more

fn window_order<E>(self, expr: E) -> WindowOrder<Self, E>
where Self: OrderWindowDsl<E>,

Add a order clause to the current window function Read more

fn frame_by<E>(self, expr: E) -> FrameBy<Self, E>
where Self: FrameDsl<E>,

Add a frame clause to the current window function Read more