Struct repr::adt::interval::Interval

pub struct Interval {
    pub months: i32,
    pub duration: i128,
}

An interval of time meant to express SQL intervals.

Obtained by parsing an INTERVAL '<value>' <unit> [TO <precision>].

Fields

months: i32

A possibly negative number of months for field types like YEAR

duration: i128

A timespan represented in nanoseconds.

Irrespective of values, duration will not be carried over into months.

Implementations

impl Interval

pub fn new(months: i32, seconds: i64, nanos: i64) -> Result<Interval, Error>

Constructs a new Interval with the specified units of time.

nanos in excess of 999_999_999 are carried over into seconds.

pub fn checked_add(&self, other: &Self) -> Option<Self>

pub fn checked_mul(&self, other: f64) -> Option<Self>

pub fn checked_div(&self, other: f64) -> Option<Self>

pub fn dur_as_secs(&self) -> i64

Returns the total number of whole seconds in the Interval’s duration.

pub fn millennia(&self) -> i32

Computes the millennium part of the interval.

The millennium part is the number of whole millennia in the interval. For example, this function returns 3 for the interval 3400 years.

pub fn centuries(&self) -> i32

Computes the century part of the interval.

The century part is the number of whole centuries in the interval. For example, this function returns 3 for the interval 340 years.

pub fn decades(&self) -> i32

Computes the decade part of the interval.

The decade part is the number of whole decades in the interval. For example, this function returns 3 for the interval 34 years.

pub fn years(&self) -> i32

Computes the year part of the interval.

The year part is the number of whole years in the interval. For example, this function returns 3 for the interval 3 years 4 months.

pub fn quarters(&self) -> i32

Computes the quarter part of the interval.

The quarter part is obtained from taking the number of whole months modulo 12, and assigning quarter #1 for months 0-2, #2 for 3-5, #3 for 6-8 and #4 for 9-11. For example, this function returns 4 for the interval 11 months.

pub fn months(&self) -> i32

Computes the month part of the interval.

The month part is the number of whole months in the interval, modulo 12. For example, this function returns 4 for the interval 3 years 4 months.

pub fn days(&self) -> i64

Computes the day part of the interval.

The day part is the number of whole days in the interval. For example, this function returns 5 for the interval 5 days 4 hours 3 minutes 2.1 seconds.

pub fn hours(&self) -> i64

Computes the hour part of the interval.

The hour part is the number of whole hours in the interval, modulo 24. For example, this function returns 4 for the interval 5 days 4 hours 3 minutes 2.1 seconds.

pub fn minutes(&self) -> i64

Computes the minute part of the interval.

The minute part is the number of whole minutes in the interval, modulo 60. For example, this function returns 3 for the interval 5 days 4 hours 3 minutes 2.1 seconds.

pub fn seconds<T>(&self) -> T where
    T: DecimalLike, 

Computes the second part of the interval.

The second part is the number of fractional seconds in the interval, modulo 60.0.

pub fn milliseconds<T>(&self) -> T where
    T: DecimalLike, 

Computes the second part of the interval displayed in milliseconds.

The second part is the number of fractional seconds in the interval, modulo 60.0.

pub fn microseconds<T>(&self) -> T where
    T: DecimalLike, 

Computes the second part of the interval displayed in microseconds.

The second part is the number of fractional seconds in the interval, modulo 60.0.

pub fn nanoseconds(&self) -> i32

Computes the nanosecond part of the interval.

pub fn as_seconds<T>(&self) -> T where
    T: DecimalLike, 

Computes the total number of seconds in the interval.

pub fn truncate_high_fields(&mut self, f: DateTimeField)

Truncate the “head” of the interval, removing all time units greater than f.

pub fn duration_as_chrono(&self) -> Duration

Converts this Interval’s duration into chrono::Duration.

pub fn duration(&self) -> Result<Duration, Error>

pub fn truncate_low_fields(
    &mut self,
    f: DateTimeField,
    fsec_max_precision: Option<u64>
) -> Result<(), Error>

Truncate the “tail” of the interval, removing all time units less than f.

Arguments

• f: Round the interval down to the specified time unit.
• fsec_max_precision: If Some(x), keep only x places of nanosecond precision. Must be (0,6).

Errors

• If fsec_max_precision is not None or within (0,6).

Trait Implementations

impl<'a> AsColumnType for Interval

fn as_column_type() -> ColumnType

The SQL column type of this Rust type

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<'a, E> DatumType<'a, E> for Interval

fn nullable() -> bool

Whether this Rust type can represent NULL values

fn try_from_result(
    res: Result<Datum<'a>, E>
) -> Result<Self, Result<Datum<'a>, E>>

Try to convert a Result whose Ok variant is a Datum into this native Rust type (Self). If it fails the error variant will contain the original result.

fn into_result(self, _temp_storage: &'a RowArena) -> Result<Datum<'a>, E>

Convert this Rust type into a Result containing a Datum, or an error

impl Debug for Interval

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

Formats the value using the given formatter.

impl Default for Interval

fn default() -> Self

Returns the “default value” for a type.

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

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

Deserialize this value from the given Serde deserializer.

impl Display for Interval

Format an interval in a human form

Example outputs:

• 1 year 2 months 5 days 03:04:00
• -1 year +5 days +18:59:29.3
• 00:00:00

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

Formats the value using the given formatter.

impl<'a> From<Interval> for Datum<'a>

fn from(other: Interval) -> Datum<'a>

Performs the conversion.

impl Hash for Interval

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

Feeds this value into the given Hasher.

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

Feeds a slice of this type into the given Hasher.

impl Neg for Interval

type Output = Self

The resulting type after applying the - operator.

fn neg(self) -> Self

Performs the unary - operation.

impl Ord for Interval

fn cmp(&self, other: &Interval) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

Restrict a value to a certain interval.

impl PartialEq<Interval> for Interval

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

This method tests for self and other values to be equal, and is used by ==.

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

This method tests for !=.

impl PartialOrd<Interval> for Interval

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

This method returns an ordering between self and other values if one exists.

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

This method tests less than (for self and other) and is used by the < operator.

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

This method tests less than or equal to (for self and other) and is used by the <= operator.

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

This method tests greater than (for self and other) and is used by the > operator.

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

This method tests greater than or equal to (for self and other) and is used by the >= operator.

impl Serialize for Interval

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

Serialize this value into the given Serde serializer.

impl Copy for Interval

impl Eq for Interval

impl StructuralEq for Interval

impl StructuralPartialEq for Interval