Struct sqldatetime::Date

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

Date represents a valid Gregorian date.

Implementations

impl Date

pub const MIN: Self = _

The smallest date that can be represented by Date, i.e. 0001-01-01.

pub const MAX: Self = _

The largest date that can be represented by Date, i.e. 9999-12-31.

pub const unsafe fn from_ymd_unchecked(year: i32, month: u32, day: u32) -> Date

Creates a Date from the given year, month, and day.

Safety

This function is unsafe because the values are not checked for validity! Before using it, check that the values are all correct.

pub const fn try_from_ymd(year: i32, month: u32, day: u32) -> Result<Date, Error>

Creates a Date from the given year, month, and day.

pub const fn is_valid(year: i32, month: u32, day: u32) -> bool

Checks if the given year, month, and day fields are valid.

pub const fn days(self) -> i32

Gets the days from Unix Epoch of this Date.

pub const unsafe fn from_days_unchecked(days: i32) -> Self

Creates a Date from the given days from Unix Epoch without checking validity.

Safety

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

pub const fn try_from_days(days: i32) -> Result<Self, Error>

Creates a Date from the given days from Unix Epoch.

pub const fn extract(self) -> (i32, u32, u32)

Extracts (year, month, day) from the date.

pub fn and_hms(
    self,
    hour: u32,
    minute: u32,
    sec: u32,
    usec: u32
) -> Result<Timestamp, Error>

Makes a new Timestamp from the current date, hour, minute, second and microsecond.

pub const fn and_time(self, time: Time) -> Timestamp

Makes a new Timestamp from the current date and time.

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

Formats Date by given format string.

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

Parses Date from given string and format.

pub const fn add_days(self, days: i32) -> Result<Date, Error>

Date adds days.

pub fn add_months(self, months: i32) -> Result<Date, Error>

Date adds months. The date will be adjusted. The last day of the month is not considered.

pub fn add_months2(self, months: i32) -> Result<Date, Error>

Date adds months. The date will be adjusted. The last day of the month is considered.

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

Date adds IntervalYM The date will not be adjusted.

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

Date adds IntervalDT

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

Date adds Time

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

Date subtracts Date. Returns the difference in days between two Date

pub const fn sub_days(self, days: i32) -> Result<Date, Error>

Date subtracts days.

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

Date subtracts Timestamp

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

Date subtracts IntervalYM

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

Date subtracts IntervalDT

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

Date subtracts Time

pub fn day_of_week(self) -> WeekDay

Extract day of week (1..=7 Sunday..=Saturday)

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

Get local system date

pub fn last_day_of_month(self) -> Date

Gets the last day in month of this Date.

Trait Implementations

impl Clone for Date

fn clone(&self) -> Date

Returns a copy of the value.

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

Performs copy-assignment from source.

impl DateTime for Date

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 Date

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Date

Available 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

Converts to this type from the input type.

impl Hash for Date

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 Date

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

This method returns an Ordering between self and other.

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

Compares and returns the maximum of two values.

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

Compares and returns the minimum of two values.

const fn clamp(self, min: Self, max: Self) -> Selfwhere
    Self: PartialOrd<Self>,

Restrict a value to a certain interval.

impl PartialEq<Date> for Date

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

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

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

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialEq<Date> for Date

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

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

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

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialEq<Date> for SqlDate

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

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

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

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

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 ==.

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

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

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 ==.

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

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialOrd<Date> for Date

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

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

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

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

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

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

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

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

const 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 Date

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

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

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

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

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

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

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

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

const 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 SqlDate

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

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

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

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

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

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

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

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

const 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.

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

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

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

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

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

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

const 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.

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

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

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

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

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

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

const 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 Date

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 Date

Available 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 Date

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

impl Eq for Date

impl StructuralEq for Date

impl StructuralPartialEq for Date