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

pub fn now() -> Result<Timestamp, Error>

Get local system timestamp

pub fn last_day_of_month(self) -> Timestamp

Gets the last day in month of Timestamp.

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

fn round_century(self) -> Result<Self, Error>

If year is more than half of century, rounds to the first day of next century, else truncates.

fn round_year(self) -> Result<Self, Error>

If month is bigger than June, rounds to the first day of next year, else truncates.

fn round_iso_year(self) -> Result<Self, Error>

If month is bigger than June, rounds to the first day of week in next year, else truncates.

fn round_quarter(self) -> Result<Self, Error>

Rounds up on the sixteenth day of the second month of the quarter, else truncates.

fn round_month(self) -> Result<Self, Error>

Rounds up on the sixteenth day of each month, else truncates.

fn round_week(self) -> Result<Self, Error>

Rounds up on the fifth day of each week, the same day of the week as the first day of the year, else truncates.

fn round_iso_week(self) -> Result<Self, Error>

Rounds up on the fifth day of each week, Monday be the first day of week, else truncates.

fn round_month_start_week(self) -> Result<Self, Error>

Rounds up on the fifth day of each week, the same day of the week as the first day of the month, else truncates.

fn round_day(self) -> Result<Self, Error>

Rounds up at 12:00 of each day, else truncates.

fn round_sunday_start_week(self) -> Result<Self, Error>

Rounds up on the fifth day of each week, Sunday be the first day of week, else truncates.

fn round_hour(self) -> Result<Self, Error>

Rounds up at half of each hour, else truncates.

fn round_minute(self) -> Result<Self, Error>

Rounds up at half of each minute, else truncates.

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

fn trunc_century(self) -> Result<Self, Error>

Truncates to the first day of the century.

fn trunc_year(self) -> Result<Self, Error>

Truncates to the first day of the year.

fn trunc_iso_year(self) -> Result<Self, Error>

Truncates to the first day of the first week in the year.

fn trunc_quarter(self) -> Result<Self, Error>

Truncates to the first day of the quarter.

fn trunc_month(self) -> Result<Self, Error>

Truncates to the first day of the month.

fn trunc_week(self) -> Result<Self, Error>

Truncates to the same day of the week as the first day of the year.

fn trunc_iso_week(self) -> Result<Self, Error>

Truncates to the monday of the week.

fn trunc_month_start_week(self) -> Result<Self, Error>

Truncates to the same day of the week as the first day of the month.

fn trunc_day(self) -> Result<Self, Error>

Truncates to the day.

fn trunc_sunday_start_week(self) -> Result<Self, Error>

Truncates to the sunday of the week.

fn trunc_hour(self) -> Result<Self, Error>

Truncates to the hour.

fn trunc_minute(self) -> Result<Self, Error>

Truncates to the minute.

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