Interval

Enum Interval 

Source
pub enum Interval {
    Month(i32),
    Microsecond(i64),
}
Expand description

Represents a time interval, which can be either in months or microseconds.

The Interval type is divided into two variants: Interval::Month and Interval::Microsecond. This distinction is made because the conversion between months and days is not consistent. While a year can be clearly calculated as 12 months in the solar calendar, a month can vary in the number of days (28, 30, or 31 days).

To ensure precise calculations and comparisons, intervals are represented in the smallest unambiguous units: Month for month-based intervals and Microsecond for microsecond-based intervals. Comparisons are only allowed within the same unit type to avoid ambiguity.

For more details on how comparisons are implemented, refer to the Interval::partial_cmp trait.

Variants§

§

Month(i32)

§

Microsecond(i64)

Implementations§

Source§

impl Interval

Source

pub fn parse(s: &str) -> Result<Self>

Source

pub fn to_sql_str(&self) -> String

Source§

impl Interval

Source

pub fn unary_minus(&self) -> Self

Source

pub fn add(&self, other: &Interval) -> Result<Self>

Source

pub fn subtract(&self, other: &Interval) -> Result<Self>

Source

pub fn add_date(&self, date: &NaiveDate) -> Result<NaiveDateTime>

Source

pub fn subtract_from_date(&self, date: &NaiveDate) -> Result<NaiveDateTime>

Source

pub fn add_timestamp(&self, timestamp: &NaiveDateTime) -> Result<NaiveDateTime>

Source

pub fn subtract_from_timestamp( &self, timestamp: &NaiveDateTime, ) -> Result<NaiveDateTime>

Source

pub fn add_time(&self, time: &NaiveTime) -> Result<NaiveTime>

Source

pub fn subtract_from_time(&self, time: &NaiveTime) -> Result<NaiveTime>

Source

pub fn years(years: i32) -> Self

Source

pub fn months(months: i32) -> Self

Source

pub fn extract(&self, field: &DateTimeField) -> Result<Value>

Source

pub fn days(days: i32) -> Self

Source

pub fn hours(hours: i32) -> Self

Source

pub fn minutes(minutes: i32) -> Self

Source

pub fn seconds(seconds: i64) -> Self

Source

pub fn milliseconds(milliseconds: i64) -> Self

Source

pub fn microseconds(microseconds: i64) -> Self

Source

pub fn try_from_str( value: &str, leading_field: Option<DateTimeField>, last_field: Option<DateTimeField>, ) -> Result<Self>

Trait Implementations§

Source§

impl Clone for Interval

Source§

fn clone(&self) -> Interval

Returns a duplicate of the value. Read more
1.0.0 · Source§

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

Performs copy-assignment from source. Read more
Source§

impl Debug for Interval

Source§

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

Formats the value using the given formatter. Read more
Source§

impl<'de> Deserialize<'de> for Interval

Source§

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>
where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer. Read more
Source§

impl Div<Interval> for f32

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for f64

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for i128

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for i16

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for i32

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for i64

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for i8

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for u128

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for u16

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for u32

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for u64

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<Interval> for u8

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: Interval) -> Interval

Performs the / operation. Read more
Source§

impl Div<f32> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: f32) -> Self

Performs the / operation. Read more
Source§

impl Div<f64> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: f64) -> Self

Performs the / operation. Read more
Source§

impl Div<i128> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: i128) -> Self

Performs the / operation. Read more
Source§

impl Div<i16> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: i16) -> Self

Performs the / operation. Read more
Source§

impl Div<i32> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: i32) -> Self

Performs the / operation. Read more
Source§

impl Div<i64> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: i64) -> Self

Performs the / operation. Read more
Source§

impl Div<i8> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: i8) -> Self

Performs the / operation. Read more
Source§

impl Div<u128> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: u128) -> Self

Performs the / operation. Read more
Source§

impl Div<u16> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: u16) -> Self

Performs the / operation. Read more
Source§

impl Div<u32> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: u32) -> Self

Performs the / operation. Read more
Source§

impl Div<u64> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: u64) -> Self

Performs the / operation. Read more
Source§

impl Div<u8> for Interval

Source§

type Output = Interval

The resulting type after applying the / operator.
Source§

fn div(self, rhs: u8) -> Self

Performs the / operation. Read more
Source§

impl Hash for Interval

Source§

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher. Read more
1.3.0 · Source§

fn hash_slice<H>(data: &[Self], state: &mut H)
where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher. Read more
Source§

impl IntoParamLiteral for Interval

Source§

fn into_param_literal(self) -> ParamLiteral

Converts the value into a ParamLiteral so it can be bound as a query parameter.
Source§

impl Mul<Interval> for f32

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for f64

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for i128

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for i16

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for i32

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for i64

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for i8

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for u128

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for u16

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for u32

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for u64

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<Interval> for u8

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: Interval) -> Interval

Performs the * operation. Read more
Source§

impl Mul<f32> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: f32) -> Self

Performs the * operation. Read more
Source§

impl Mul<f64> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: f64) -> Self

Performs the * operation. Read more
Source§

impl Mul<i128> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: i128) -> Self

Performs the * operation. Read more
Source§

impl Mul<i16> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: i16) -> Self

Performs the * operation. Read more
Source§

impl Mul<i32> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: i32) -> Self

Performs the * operation. Read more
Source§

impl Mul<i64> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: i64) -> Self

Performs the * operation. Read more
Source§

impl Mul<i8> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: i8) -> Self

Performs the * operation. Read more
Source§

impl Mul<u128> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: u128) -> Self

Performs the * operation. Read more
Source§

impl Mul<u16> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: u16) -> Self

Performs the * operation. Read more
Source§

impl Mul<u32> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: u32) -> Self

Performs the * operation. Read more
Source§

impl Mul<u64> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: u64) -> Self

Performs the * operation. Read more
Source§

impl Mul<u8> for Interval

Source§

type Output = Interval

The resulting type after applying the * operator.
Source§

fn mul(self, rhs: u8) -> Self

Performs the * operation. Read more
Source§

impl PartialEq for Interval

Source§

fn eq(&self, other: &Interval) -> bool

Tests for self and other values to be equal, and is used by ==.
1.0.0 · Source§

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.
Source§

impl PartialOrd for Interval

Source§

fn partial_cmp(&self, other: &Interval) -> Option<Ordering>

This method returns an ordering between self and other values if one exists. Read more
1.0.0 · Source§

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator. Read more
1.0.0 · Source§

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator. Read more
1.0.0 · Source§

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator. Read more
1.0.0 · Source§

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator. Read more
Source§

impl Serialize for Interval

Source§

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>
where __S: Serializer,

Serialize this value into the given Serde serializer. Read more
Source§

impl Copy for Interval

Source§

impl Eq for Interval

Source§

impl StructuralPartialEq for Interval

Auto Trait Implementations§

Blanket Implementations§

Source§

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

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

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

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

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

Source§

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

Mutably borrows from an owned value. Read more
Source§

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

Source§

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
Source§

impl<Q, K> Equivalent<K> for Q
where Q: Eq + ?Sized, K: Borrow<Q> + ?Sized,

Source§

fn equivalent(&self, key: &K) -> bool

Compare self to key and return true if they are equal.
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

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

Source§

fn into(self) -> U

Calls U::from(self).

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

Source§

impl<T> IntoEither for T

Source§

fn into_either(self, into_left: bool) -> Either<Self, Self>

Converts self into a Left variant of Either<Self, Self> if into_left is true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
Source§

fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
where F: FnOnce(&Self) -> bool,

Converts self into a Left variant of Either<Self, Self> if into_left(&self) returns true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
Source§

impl<T> Same for T

Source§

type Output = T

Should always be Self
Source§

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

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

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

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

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

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

Source§

type Error = Infallible

The type returned in the event of a conversion error.
Source§

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

Performs the conversion.
Source§

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

Source§

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

The type returned in the event of a conversion error.
Source§

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

Performs the conversion.
Source§

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

Source§

fn vzip(self) -> V

Source§

impl<T> DeserializeOwned for T
where T: for<'de> Deserialize<'de>,