Struct sqldatetime::Timestamp

#[repr(transparent)]
pub struct Timestamp(_);

Timestamp represents a valid time at a valid Gregorian date.

This is an SQL TIMESTAMP value, with the specification of fractional seconds to a precision of microseconds.

Implementations

impl Timestamp

pub const MIN: Self

The smallest timestamp that can be represented by Date, i.e. 0001-01-01 00:00:00.000000.

pub const MAX: Self

The largest timestamp that can be represented by Date, i.e. 9999-12-31 23:59:59.999999.

pub const fn new(date: Date, time: Time) -> Self

Creates a new Timestamp from a date and a time.

pub const fn extract(self) -> (Date, Time)

Extracts (Date, Time) from the timestamp.

pub const fn usecs(self) -> i64

Gets the microseconds from Unix Epoch of Timestamp.

pub const unsafe fn from_usecs_unchecked(usecs: i64) -> Self

Creates a Timestamp from the given microseconds from Unix Epoch without checking validity.

Safety

This function is unsafe because the microsecond value is not checked for validity! Before using it, check that the value is correct.

pub fn format<S: AsRef<str>>(self, fmt: S) -> Result<impl Display, Error>

Formats Timestamp by given format string.

pub fn parse<S1: AsRef<str>, S2: AsRef<str>>(
    input: S1,
    fmt: S2
) -> Result<Self, Error>

Parses Timestamp from given string and format.

pub const fn try_from_usecs(usecs: i64) -> Result<Self, Error>

Creates a Timestamp from the given microseconds from Unix Epoch

pub const fn add_interval_dt(
    self,
    interval: IntervalDT
) -> Result<Timestamp, Error>

Timestamp adds IntervalDT

pub fn add_interval_ym(self, interval: IntervalYM) -> Result<Timestamp, Error>

Timestamp adds IntervalYM

pub const fn add_time(self, time: Time) -> Result<Timestamp, Error>

Timestamp add Time

pub fn add_days(self, days: f64) -> Result<Timestamp, Error>

Timestamp add days

pub const fn sub_date(self, date: Date) -> IntervalDT

Timestamp subtracts Date

pub const fn sub_time(self, time: Time) -> Result<Timestamp, Error>

Timestamp subtracts Time

pub const fn sub_timestamp(self, timestamp: Timestamp) -> IntervalDT

Timestamp subtracts Timestamp

pub const fn sub_interval_dt(
    self,
    interval: IntervalDT
) -> Result<Timestamp, Error>

Timestamp subtracts IntervalDT

pub fn sub_interval_ym(self, interval: IntervalYM) -> Result<Timestamp, Error>

Timestamp subtracts IntervalYM

pub fn sub_days(self, days: f64) -> Result<Timestamp, Error>

Timestamp subtracts days

impl Timestamp

pub const fn oracle_sub_date(self, date: Date) -> IntervalDT

Timestamp subtracts Date

pub fn oracle_add_days(self, days: f64) -> Result<Date, Error>

Timestamp add days

pub fn oracle_sub_days(self, days: f64) -> Result<Date, Error>

Timestamp subtracts days

Trait Implementations

impl Clone for Timestamp

fn clone(&self) -> Timestamp

Returns a copy of the value.

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

Performs copy-assignment from source.

impl DateTime for Timestamp

fn year(&self) -> Option<i32>

Extracts year from date time.

fn month(&self) -> Option<i32>

Extracts month from date time.

fn day(&self) -> Option<i32>

Extracts day from date time.

fn hour(&self) -> Option<i32>

Extracts hour from date time.

fn minute(&self) -> Option<i32>

Extracts minute from date time.

fn second(&self) -> Option<f64>

Extracts second from date time.

fn date(&self) -> Option<Date>

Extracts second from date time.

impl Debug for Timestamp

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Timestamp

This is supported on crate feature serde only.

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

Deserialize this value from the given Serde deserializer.

impl From<Date> for Timestamp

fn from(date: Date) -> Self

Performs the conversion.

impl From<Date> for Timestamp

fn from(input: Date) -> Self

Performs the conversion.

impl From<Timestamp> for Time

fn from(timestamp: Timestamp) -> Self

Performs the conversion.

impl From<Timestamp> for Date

fn from(timestamp: Timestamp) -> Self

Performs the conversion.

impl Hash for Timestamp

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 Ord for Timestamp

fn cmp(&self, other: &Timestamp) -> 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<Date> for Timestamp

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

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

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

This method tests for !=.

impl PartialEq<Date> for Timestamp

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

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

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

This method tests for !=.

impl PartialEq<Timestamp> for Date

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

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

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

This method tests for !=.

impl PartialEq<Timestamp> for Timestamp

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

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

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

This method tests for !=.

impl PartialEq<Timestamp> for Date

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

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

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

This method tests for !=.

impl PartialOrd<Date> for Timestamp

fn partial_cmp(&self, other: &Date) -> 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 PartialOrd<Date> for Timestamp

fn partial_cmp(&self, other: &Date) -> 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 PartialOrd<Timestamp> for Date

fn partial_cmp(&self, other: &Timestamp) -> 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 PartialOrd<Timestamp> for Timestamp

fn partial_cmp(&self, other: &Timestamp) -> 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 PartialOrd<Timestamp> for Date

fn partial_cmp(&self, other: &Timestamp) -> 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 Timestamp

This is supported on crate feature serde only.

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

Serialize this value into the given Serde serializer.

impl TryFrom<Time> for Timestamp

type Error = Error

The type returned in the event of a conversion error.

fn try_from(time: Time) -> Result<Self, Error>

Performs the conversion.

impl Copy for Timestamp

impl Eq for Timestamp

impl StructuralEq for Timestamp

impl StructuralPartialEq for Timestamp