Struct DateTime

pub struct DateTime { /* private fields */ }

A representation of a date and time.

Implementations

impl DateTime

pub const fn ymd(year: i16, month: u8, day: u8) -> DateTimeBuilder

Create a new date and time object.

pub const fn from_timestamp(timestamp: i64, nanos: u32) -> Self

Create a new date and time object from the given Unix timestamp.

pub const fn from_timestamp_millis(millis: i64) -> Self

Create a new date and time object from the given Unix timestamp in milliseconds.

pub const fn from_timestamp_micros(micros: i64) -> Self

Create a new date and time object from the given Unix timestamp in microseconds.

pub const fn from_timestamp_nanos(nanos: i128) -> Self

Create a new date and time object from the given Unix timestamp in nanoseconds.

pub fn now() -> Self

Return the current timestamp.

Panic

Panics if the system clock is set prior to January 1, 1970.

impl DateTime

pub const fn with_tz(self, tz: TimeZoneRef<'static>) -> Self

Set the time zone to the provided time zone, without adjusting the underlying absolute timestamp.

This method modifies the wall clock time while maintaining the underlying absolute timestamp. To modify the timestamp instead, use in_tz.

pub const fn in_tz(self, tz: TimeZoneRef<'static>) -> Self

Set the timestamp to the same wall clock time in the provided time zone.

This method modifies the underlying timestamp while maintaining the wall clock time. To maintain the timestamp instead, use with_tz.

impl DateTime

Accessors

pub const fn year(&self) -> i16

The year for this date.

pub const fn month(&self) -> u8

The month for this date.

pub const fn day(&self) -> u8

The day of the month for this date.

pub const fn weekday(&self) -> Weekday

The day of the week for this date.

pub const fn hour(&self) -> u8

The hour of the day for this date and time. Range: [0, 24)

pub const fn minute(&self) -> u8

The minute of the hour for this date and time. Range: [0, 60)

pub const fn second(&self) -> u8

The second of the minute for this date and time. Range: [0, 60)

pub const fn nanosecond(&self) -> u32

The nanosecond of the second for this date and time. Range: [0, 1_000_000_000)

pub const fn day_of_year(&self) -> u16

The ordinal day of the year.

pub const fn date(&self) -> Date

The date corresponding to this datetime.

pub const fn as_seconds(&self) -> i64

The number of seconds since the Unix epoch for this date and time.

pub const fn as_milliseconds(&self) -> i64

The number of milliseconds since the Unix epoch for this date and time.

pub const fn as_microseconds(&self) -> i64

The number of microseconds since the Unix epoch for this date and time.

pub const fn as_nanoseconds(&self) -> i128

The number of nanoseconds since the Unix epoch for this date and time.

pub const fn precision(&self) -> Precision

The precision required to represent this timestamp with no fidelity loss.

impl DateTime

pub fn format(&self, format: &'static str) -> FormattedDateTime<'_>

Format the given date and time according to the provided strftime-like string.

impl DateTime

pub fn parse( datetime_str: impl AsRef<str>, fmt: &'static str, ) -> ParseResult<Self>

Parse a date from a string, according to the provided format string.

Trait Implementations

impl Add<TimeInterval> for DateTime

type Output = DateTime

The resulting type after applying the + operator.

fn add(self, rhs: TimeInterval) -> Self::Output

Performs the + operation.

impl AddAssign<TimeInterval> for DateTime

fn add_assign(&mut self, rhs: TimeInterval)

Performs the += operation.

impl<'__expr> AsExpression<Nullable<Timestamp>> for &'__expr DateTime

type Expression = Bound<Nullable<Timestamp>, &'__expr DateTime>

The expression being returned

fn as_expression( self, ) -> <Self as AsExpression<Nullable<Timestamp>>>::Expression

Perform the conversion

impl AsExpression<Nullable<Timestamp>> for DateTime

type Expression = Bound<Nullable<Timestamp>, DateTime>

The expression being returned

fn as_expression( self, ) -> <Self as AsExpression<Nullable<Timestamp>>>::Expression

Perform the conversion

impl<'__expr> AsExpression<Nullable<Timestamptz>> for &'__expr DateTime

type Expression = Bound<Nullable<Timestamptz>, &'__expr DateTime>

The expression being returned

fn as_expression( self, ) -> <Self as AsExpression<Nullable<Timestamptz>>>::Expression

Perform the conversion

impl AsExpression<Nullable<Timestamptz>> for DateTime

type Expression = Bound<Nullable<Timestamptz>, DateTime>

The expression being returned

fn as_expression( self, ) -> <Self as AsExpression<Nullable<Timestamptz>>>::Expression

Perform the conversion

impl<'__expr> AsExpression<Timestamp> for &'__expr DateTime

type Expression = Bound<Timestamp, &'__expr DateTime>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Timestamp>>::Expression

Perform the conversion

impl AsExpression<Timestamp> for DateTime

type Expression = Bound<Timestamp, DateTime>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Timestamp>>::Expression

Perform the conversion

impl<'__expr> AsExpression<Timestamptz> for &'__expr DateTime

type Expression = Bound<Timestamptz, &'__expr DateTime>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Timestamptz>>::Expression

Perform the conversion

impl AsExpression<Timestamptz> for DateTime

type Expression = Bound<Timestamptz, DateTime>

The expression being returned

fn as_expression(self) -> <Self as AsExpression<Timestamptz>>::Expression

Perform the conversion

impl Clone for DateTime

fn clone(&self) -> DateTime

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for DateTime

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for DateTime

Available on crate feature serde only.

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

Deserialize this value from the given Serde deserializer.

impl FromSql<Timestamp, Pg> for DateTime

fn from_sql(bytes: PgValue<'_>) -> DeserializeResult<Self>

See the trait documentation.

fn from_nullable_sql( bytes: Option<<DB as Backend>::RawValue<'_>>, ) -> Result<Self, Box<dyn Error + Sync + Send>>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamptz, Pg> for DateTime

fn from_sql(bytes: PgValue<'_>) -> DeserializeResult<Self>

See the trait documentation.

fn from_nullable_sql( bytes: Option<<DB as Backend>::RawValue<'_>>, ) -> Result<Self, Box<dyn Error + Sync + Send>>

A specialized variant of from_sql for handling null values.

impl FromSql for DateTime

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

Converts DuckDB value into Rust value.

impl FromStr for DateTime

type Err = ParseError

The associated error which can be returned from parsing.

fn from_str(s: &str) -> ParseResult<Self>

Parses a string s to return a value of this type.

impl Ord for DateTime

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

This method returns an Ordering between self and other.

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

where Self: Sized,

Compares and returns the maximum of two values.

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

where Self: Sized,

Compares and returns the minimum of two values.

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

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for DateTime

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

Tests for self and other values to be equal, and is used by ==.

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

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

impl PartialOrd for DateTime

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

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

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

Tests less than (for self and other) and is used by the < operator.

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

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

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

Tests greater than (for self and other) and is used by the > operator.

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

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

impl<__DB, __ST> Queryable<__ST, __DB> for DateTime

where __DB: Backend, __ST: SingleValue, Self: FromSql<__ST, __DB>,

type Row = DateTime

The Rust type you’d like to map from.

fn build(row: Self) -> Result<Self>

Construct an instance of this type

impl Serialize for DateTime

Available on crate feature serde only.

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

Serialize this value into the given Serde serializer.

impl Sub<TimeInterval> for DateTime

type Output = DateTime

The resulting type after applying the - operator.

fn sub(self, rhs: TimeInterval) -> Self::Output

Performs the - operation.

impl Sub for DateTime

type Output = TimeInterval

The resulting type after applying the - operator.

fn sub(self, rhs: Self) -> Self::Output

Performs the - operation.

impl SubAssign<TimeInterval> for DateTime

fn sub_assign(&mut self, rhs: TimeInterval)

Performs the -= operation.

impl<__DB> ToSql<Nullable<Timestamp>, __DB> for DateTime

where __DB: Backend, Self: ToSql<Timestamp, __DB>,

fn to_sql<'__b>(&'__b self, out: &mut Output<'__b, '_, __DB>) -> Result

See the trait documentation.

impl<__DB> ToSql<Nullable<Timestamptz>, __DB> for DateTime

where __DB: Backend, Self: ToSql<Timestamptz, __DB>,

fn to_sql<'__b>(&'__b self, out: &mut Output<'__b, '_, __DB>) -> Result

See the trait documentation.

impl ToSql<Timestamp, Pg> for DateTime

fn to_sql<'se>(&'se self, out: &mut Output<'se, '_, Pg>) -> SerializeResult

See the trait documentation.

impl ToSql<Timestamptz, Pg> for DateTime

fn to_sql<'se>(&'se self, out: &mut Output<'se, '_, Pg>) -> SerializeResult

See the trait documentation.

impl ToSql for DateTime

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

Converts Rust value to DuckDB value

impl ToValue for DateTime

fn to_value(&self) -> Value<'_>

Perform the conversion.

impl TryFrom<RawDateTime> for DateTime

type Error = ParseError

The type returned in the event of a conversion error.

fn try_from(value: RawDateTime) -> ParseResult<Self>

Performs the conversion.

impl Copy for DateTime

impl Eq for DateTime