Struct sqlx::types::chrono::DateTime

pub struct DateTime<Tz> where
    Tz: TimeZone,  { /* fields omitted */ }

ISO 8601 combined date and time with time zone.

There are some constructors implemented here (the from_* methods), but the general-purpose constructors are all via the methods on the TimeZone implementations.

Implementations

impl<Tz> DateTime<Tz> where
    Tz: TimeZone, 

pub fn from_utc(
    datetime: NaiveDateTime,
    offset: <Tz as TimeZone>::Offset
) -> DateTime<Tz>

Makes a new DateTime with given UTC datetime and offset. The local datetime should be constructed via the TimeZone trait.

Example

use chrono::{DateTime, TimeZone, NaiveDateTime, Utc};

let dt = DateTime::<Utc>::from_utc(NaiveDateTime::from_timestamp(61, 0), Utc);
assert_eq!(Utc.timestamp(61, 0), dt);

pub fn date(&self) -> Date<Tz>

Retrieves a date component.

pub fn time(&self) -> NaiveTime

Retrieves a time component. Unlike date, this is not associated to the time zone.

pub fn timestamp(&self) -> i64

Returns the number of non-leap seconds since January 1, 1970 0:00:00 UTC (aka “UNIX timestamp”).

pub fn timestamp_millis(&self) -> i64

Returns the number of non-leap-milliseconds since January 1, 1970 UTC

Note that this does reduce the number of years that can be represented from ~584 Billion to ~584 Million. (If this is a problem, please file an issue to let me know what domain needs millisecond precision over billions of years, I’m curious.)

Example

use chrono::Utc;
use chrono::TimeZone;

let dt = Utc.ymd(1970, 1, 1).and_hms_milli(0, 0, 1, 444);
assert_eq!(dt.timestamp_millis(), 1_444);

let dt = Utc.ymd(2001, 9, 9).and_hms_milli(1, 46, 40, 555);
assert_eq!(dt.timestamp_millis(), 1_000_000_000_555);

pub fn timestamp_nanos(&self) -> i64

Returns the number of non-leap-nanoseconds since January 1, 1970 UTC

Note that this does reduce the number of years that can be represented from ~584 Billion to ~584. (If this is a problem, please file an issue to let me know what domain needs nanosecond precision over millennia, I’m curious.)

Example

use chrono::Utc;
use chrono::TimeZone;

let dt = Utc.ymd(1970, 1, 1).and_hms_nano(0, 0, 1, 444);
assert_eq!(dt.timestamp_nanos(), 1_000_000_444);

let dt = Utc.ymd(2001, 9, 9).and_hms_nano(1, 46, 40, 555);
assert_eq!(dt.timestamp_nanos(), 1_000_000_000_000_000_555);

pub fn timestamp_subsec_millis(&self) -> u32

Returns the number of milliseconds since the last second boundary

warning: in event of a leap second, this may exceed 999

note: this is not the number of milliseconds since January 1, 1970 0:00:00 UTC

pub fn timestamp_subsec_micros(&self) -> u32

Returns the number of microseconds since the last second boundary

warning: in event of a leap second, this may exceed 999_999

note: this is not the number of microseconds since January 1, 1970 0:00:00 UTC

pub fn timestamp_subsec_nanos(&self) -> u32

Returns the number of nanoseconds since the last second boundary

warning: in event of a leap second, this may exceed 999_999_999

note: this is not the number of nanoseconds since January 1, 1970 0:00:00 UTC

pub fn offset(&self) -> &<Tz as TimeZone>::Offset

Retrieves an associated offset from UTC.

pub fn timezone(&self) -> Tz

Retrieves an associated time zone.

pub fn with_timezone<Tz2>(&self, tz: &Tz2) -> DateTime<Tz2> where
    Tz2: TimeZone, 

Changes the associated time zone. This does not change the actual DateTime (but will change the string representation).

pub fn checked_add_signed(self, rhs: Duration) -> Option<DateTime<Tz>>

Adds given Duration to the current date and time.

Returns None when it will result in overflow.

pub fn checked_sub_signed(self, rhs: Duration) -> Option<DateTime<Tz>>

Subtracts given Duration from the current date and time.

Returns None when it will result in overflow.

pub fn signed_duration_since<Tz2>(self, rhs: DateTime<Tz2>) -> Duration where
    Tz2: TimeZone, 

Subtracts another DateTime from the current date and time. This does not overflow or underflow at all.

pub fn naive_utc(&self) -> NaiveDateTime

Returns a view to the naive UTC datetime.

pub fn naive_local(&self) -> NaiveDateTime

Returns a view to the naive local datetime.

impl DateTime<FixedOffset>

pub fn parse_from_rfc2822(s: &str) -> Result<DateTime<FixedOffset>, ParseError>

Parses an RFC 2822 date and time string such as Tue, 1 Jul 2003 10:52:37 +0200, then returns a new DateTime with a parsed FixedOffset.

RFC 2822 is the internet message standard that specifices the representation of times in HTTP and email headers.

assert_eq!(
    DateTime::parse_from_rfc2822("Wed, 18 Feb 2015 23:16:09 GMT").unwrap(),
    FixedOffset::east(0).ymd(2015, 2, 18).and_hms(23, 16, 9)
);

pub fn parse_from_rfc3339(s: &str) -> Result<DateTime<FixedOffset>, ParseError>

Parses an RFC 3339 and ISO 8601 date and time string such as 1996-12-19T16:39:57-08:00, then returns a new DateTime with a parsed FixedOffset.

Why isn’t this named parse_from_iso8601? That’s because ISO 8601 allows some freedom over the syntax and RFC 3339 exercises that freedom to rigidly define a fixed format.

pub fn parse_from_str(
    s: &str,
    fmt: &str
) -> Result<DateTime<FixedOffset>, ParseError>

Parses a string with the specified format string and returns a new DateTime with a parsed FixedOffset. See the format::strftime module on the supported escape sequences.

See also Offset::datetime_from_str which gives a local DateTime on specific time zone.

Note that this method requires a timezone in the string. See NaiveDateTime::parse_from_str for a version that does not require a timezone in the to-be-parsed str.

Example

use chrono::{DateTime, FixedOffset, TimeZone};

let dt = DateTime::parse_from_str(
    "1983 Apr 13 12:09:14.274 +0000", "%Y %b %d %H:%M:%S%.3f %z");
assert_eq!(dt, Ok(FixedOffset::east(0).ymd(1983, 4, 13).and_hms_milli(12, 9, 14, 274)));

impl<Tz> DateTime<Tz> where
    Tz: TimeZone,
    <Tz as TimeZone>::Offset: Display, 

pub fn to_rfc2822(&self) -> String

Returns an RFC 2822 date and time string such as Tue, 1 Jul 2003 10:52:37 +0200.

pub fn to_rfc3339(&self) -> String

Returns an RFC 3339 and ISO 8601 date and time string such as 1996-12-19T16:39:57-08:00.

pub fn to_rfc3339_opts(&self, secform: SecondsFormat, use_z: bool) -> String

Return an RFC 3339 and ISO 8601 date and time string with subseconds formatted as per a SecondsFormat. If passed use_z true and the timezone is UTC (offset 0), use ‘Z’, as per Fixed::TimezoneOffsetColonZ. If passed use_z false, use Fixed::TimezoneOffsetColon.

Examples

let dt = Utc.ymd(2018, 1, 26).and_hms_micro(18, 30, 9, 453_829);
assert_eq!(dt.to_rfc3339_opts(SecondsFormat::Millis, false),
           "2018-01-26T18:30:09.453+00:00");
assert_eq!(dt.to_rfc3339_opts(SecondsFormat::Millis, true),
           "2018-01-26T18:30:09.453Z");
assert_eq!(dt.to_rfc3339_opts(SecondsFormat::Secs, true),
           "2018-01-26T18:30:09Z");

let pst = FixedOffset::east(8 * 60 * 60);
let dt = pst.ymd(2018, 1, 26).and_hms_micro(10, 30, 9, 453_829);
assert_eq!(dt.to_rfc3339_opts(SecondsFormat::Secs, true),
           "2018-01-26T10:30:09+08:00");

pub fn format_with_items<'a, I, B>(&self, items: I) -> DelayedFormat<I> where
    I: Iterator<Item = B> + Clone,
    B: Borrow<Item<'a>>, 

Formats the combined date and time with the specified formatting items.

pub fn format(&self, fmt: &'a str) -> DelayedFormat<StrftimeItems<'a>>

Formats the combined date and time with the specified format string. See the format::strftime module on the supported escape sequences.

Trait Implementations

impl<Tz> Add<Duration> for DateTime<Tz> where
    Tz: TimeZone, 

type Output = DateTime<Tz>

The resulting type after applying the + operator.

pub fn add(self, rhs: Duration) -> DateTime<Tz>

Performs the + operation.

impl<Tz> Add<FixedOffset> for DateTime<Tz> where
    Tz: TimeZone, 

type Output = DateTime<Tz>

The resulting type after applying the + operator.

pub fn add(self, rhs: FixedOffset) -> DateTime<Tz>

Performs the + operation.

impl<Tz> Clone for DateTime<Tz> where
    Tz: Clone + TimeZone,
    <Tz as TimeZone>::Offset: Clone, 

pub fn clone(&self) -> DateTime<Tz>

Returns a copy of the value.

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

Performs copy-assignment from source.

impl<Tz> Datelike for DateTime<Tz> where
    Tz: TimeZone, 

pub fn year(&self) -> i32

Returns the year number in the calendar date.

pub fn month(&self) -> u32

Returns the month number starting from 1.

pub fn month0(&self) -> u32

Returns the month number starting from 0.

pub fn day(&self) -> u32

Returns the day of month starting from 1.

pub fn day0(&self) -> u32

Returns the day of month starting from 0.

pub fn ordinal(&self) -> u32

Returns the day of year starting from 1.

pub fn ordinal0(&self) -> u32

Returns the day of year starting from 0.

pub fn weekday(&self) -> Weekday

Returns the day of week.

pub fn iso_week(&self) -> IsoWeek

Returns the ISO week.

pub fn with_year(&self, year: i32) -> Option<DateTime<Tz>>

Makes a new value with the year number changed.

pub fn with_month(&self, month: u32) -> Option<DateTime<Tz>>

Makes a new value with the month number (starting from 1) changed.

pub fn with_month0(&self, month0: u32) -> Option<DateTime<Tz>>

Makes a new value with the month number (starting from 0) changed.

pub fn with_day(&self, day: u32) -> Option<DateTime<Tz>>

Makes a new value with the day of month (starting from 1) changed.

pub fn with_day0(&self, day0: u32) -> Option<DateTime<Tz>>

Makes a new value with the day of month (starting from 0) changed.

pub fn with_ordinal(&self, ordinal: u32) -> Option<DateTime<Tz>>

Makes a new value with the day of year (starting from 1) changed.

pub fn with_ordinal0(&self, ordinal0: u32) -> Option<DateTime<Tz>>

Makes a new value with the day of year (starting from 0) changed.

fn year_ce(&self) -> (bool, u32)

Returns the absolute year number starting from 1 with a boolean flag, which is false when the year predates the epoch (BCE/BC) and true otherwise (CE/AD).

fn num_days_from_ce(&self) -> i32

Counts the days in the proleptic Gregorian calendar, with January 1, Year 1 (CE) as day 1.

impl<Tz> Debug for DateTime<Tz> where
    Tz: TimeZone, 

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

Formats the value using the given formatter.

impl<'r> Decode<'r, MySql> for DateTime<Utc>

pub fn decode(
    value: MySqlValueRef<'r>
) -> Result<DateTime<Utc>, Box<dyn Error + 'static + Sync + Send, Global>>

Decode a new value of this type using a raw value from the database.

impl<'r> Decode<'r, Postgres> for DateTime<FixedOffset>

pub fn decode(
    value: PgValueRef<'r>
) -> Result<DateTime<FixedOffset>, Box<dyn Error + 'static + Sync + Send, Global>>

Decode a new value of this type using a raw value from the database.

impl<'r> Decode<'r, Postgres> for DateTime<Utc>

pub fn decode(
    value: PgValueRef<'r>
) -> Result<DateTime<Utc>, Box<dyn Error + 'static + Sync + Send, Global>>

Decode a new value of this type using a raw value from the database.

impl<'r> Decode<'r, Postgres> for DateTime<Local>

pub fn decode(
    value: PgValueRef<'r>
) -> Result<DateTime<Local>, Box<dyn Error + 'static + Sync + Send, Global>>

Decode a new value of this type using a raw value from the database.

impl<'r> Decode<'r, Sqlite> for DateTime<FixedOffset>

pub fn decode(
    value: SqliteValueRef<'r>
) -> Result<DateTime<FixedOffset>, Box<dyn Error + 'static + Sync + Send, Global>>

Decode a new value of this type using a raw value from the database.

impl<'r> Decode<'r, Sqlite> for DateTime<Utc>

pub fn decode(
    value: SqliteValueRef<'r>
) -> Result<DateTime<Utc>, Box<dyn Error + 'static + Sync + Send, Global>>

Decode a new value of this type using a raw value from the database.

impl<'r> Decode<'r, Sqlite> for DateTime<Local>

pub fn decode(
    value: SqliteValueRef<'r>
) -> Result<DateTime<Local>, Box<dyn Error + 'static + Sync + Send, Global>>

Decode a new value of this type using a raw value from the database.

impl<Tz> Display for DateTime<Tz> where
    Tz: TimeZone,
    <Tz as TimeZone>::Offset: Display, 

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

Formats the value using the given formatter.

impl<Tz> DurationRound for DateTime<Tz> where
    Tz: TimeZone, 

type Err = RoundingError

Error that can occur in rounding or truncating

pub fn duration_round(
    self,
    duration: Duration
) -> Result<DateTime<Tz>, <DateTime<Tz> as DurationRound>::Err>

Return a copy rounded by Duration.

pub fn duration_trunc(
    self,
    duration: Duration
) -> Result<DateTime<Tz>, <DateTime<Tz> as DurationRound>::Err>

Return a copy truncated by Duration.

impl<'_> Encode<'_, MySql> for DateTime<Utc>

pub fn encode_by_ref(&self, buf: &mut Vec<u8, Global>) -> IsNull

Writes the value of self into buf without moving self.

#[must_use]

fn encode(self, buf: &mut <DB as HasArguments<'q>>::ArgumentBuffer) -> IsNull

Writes the value of self into buf in the expected format for the database.

fn produces(&self) -> Option<<DB as Database>::TypeInfo>

fn size_hint(&self) -> usize

impl<'_, Tz> Encode<'_, Postgres> for DateTime<Tz> where
    Tz: TimeZone, 

pub fn encode_by_ref(&self, buf: &mut PgArgumentBuffer) -> IsNull

Writes the value of self into buf without moving self.

pub fn size_hint(&self) -> usize

#[must_use]

fn encode(self, buf: &mut <DB as HasArguments<'q>>::ArgumentBuffer) -> IsNull

Writes the value of self into buf in the expected format for the database.

fn produces(&self) -> Option<<DB as Database>::TypeInfo>

impl<'_, Tz> Encode<'_, Sqlite> for DateTime<Tz> where
    Tz: TimeZone,
    <Tz as TimeZone>::Offset: Display, 

pub fn encode_by_ref(
    &self,
    buf: &mut Vec<SqliteArgumentValue<'_>, Global>
) -> IsNull

Writes the value of self into buf without moving self.

#[must_use]

fn encode(self, buf: &mut <DB as HasArguments<'q>>::ArgumentBuffer) -> IsNull

Writes the value of self into buf in the expected format for the database.

fn produces(&self) -> Option<<DB as Database>::TypeInfo>

fn size_hint(&self) -> usize

impl From<DateTime<FixedOffset>> for DateTime<Local>

Convert a DateTime<FixedOffset> instance into a DateTime<Local> instance.

pub fn from(src: DateTime<FixedOffset>) -> DateTime<Local>

Convert this DateTime<FixedOffset> instance into a DateTime<Local> instance.

Conversion is performed via DateTime::with_timezone. Returns the equivalent value in local time.

impl From<DateTime<FixedOffset>> for DateTime<Utc>

Convert a DateTime<FixedOffset> instance into a DateTime<Utc> instance.

pub fn from(src: DateTime<FixedOffset>) -> DateTime<Utc>

Convert this DateTime<FixedOffset> instance into a DateTime<Utc> instance.

Conversion is performed via DateTime::with_timezone, accounting for the timezone difference.

impl From<DateTime<Local>> for DateTime<FixedOffset>

Convert a DateTime<Local> instance into a DateTime<FixedOffset> instance.

pub fn from(src: DateTime<Local>) -> DateTime<FixedOffset>

Convert this DateTime<Local> instance into a DateTime<FixedOffset> instance.

Conversion is performed via DateTime::with_timezone. Note that the converted value returned by this will be created with a fixed timezone offset of 0.

impl From<DateTime<Local>> for DateTime<Utc>

Convert a DateTime<Local> instance into a DateTime<Utc> instance.

pub fn from(src: DateTime<Local>) -> DateTime<Utc>

Convert this DateTime<Local> instance into a DateTime<Utc> instance.

Conversion is performed via DateTime::with_timezone, accounting for the difference in timezones.

impl From<DateTime<Utc>> for DateTime<FixedOffset>

Convert a DateTime<Utc> instance into a DateTime<FixedOffset> instance.

pub fn from(src: DateTime<Utc>) -> DateTime<FixedOffset>

Convert this DateTime<Utc> instance into a DateTime<FixedOffset> instance.

Conversion is done via DateTime::with_timezone. Note that the converted value returned by this will be created with a fixed timezone offset of 0.

impl From<DateTime<Utc>> for DateTime<Local>

Convert a DateTime<Utc> instance into a DateTime<Local> instance.

pub fn from(src: DateTime<Utc>) -> DateTime<Local>

Convert this DateTime<Utc> instance into a DateTime<Local> instance.

Conversion is performed via DateTime::with_timezone, accounting for the difference in timezones.

impl From<SystemTime> for DateTime<Utc>

pub fn from(t: SystemTime) -> DateTime<Utc>

Performs the conversion.

impl From<SystemTime> for DateTime<Local>

pub fn from(t: SystemTime) -> DateTime<Local>

Performs the conversion.

impl FromStr for DateTime<FixedOffset>

type Err = ParseError

The associated error which can be returned from parsing.

pub fn from_str(s: &str) -> Result<DateTime<FixedOffset>, ParseError>

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

impl FromStr for DateTime<Utc>

type Err = ParseError

The associated error which can be returned from parsing.

pub fn from_str(s: &str) -> Result<DateTime<Utc>, ParseError>

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

impl FromStr for DateTime<Local>

type Err = ParseError

The associated error which can be returned from parsing.

pub fn from_str(s: &str) -> Result<DateTime<Local>, ParseError>

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

impl<Tz> Hash for DateTime<Tz> where
    Tz: TimeZone, 

pub fn hash<H>(&self, state: &mut H) where
    H: Hasher, 

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<Tz> Ord for DateTime<Tz> where
    Tz: TimeZone, 

pub fn cmp(&self, other: &DateTime<Tz>) -> Ordering

This method returns an Ordering between self and other.

#[must_use]

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

Compares and returns the maximum of two values.

#[must_use]

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

Compares and returns the minimum of two values.

#[must_use]

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

Restrict a value to a certain interval.

impl<Tz, Tz2> PartialEq<DateTime<Tz2>> for DateTime<Tz> where
    Tz: TimeZone,
    Tz2: TimeZone, 

pub fn eq(&self, other: &DateTime<Tz2>) -> bool

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

#[must_use]

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

This method tests for !=.

impl<Tz, Tz2> PartialOrd<DateTime<Tz2>> for DateTime<Tz> where
    Tz: TimeZone,
    Tz2: TimeZone, 

pub fn partial_cmp(&self, other: &DateTime<Tz2>) -> Option<Ordering>

Compare two DateTimes based on their true time, ignoring time zones

Example

use chrono::prelude::*;

let earlier = Utc.ymd(2015, 5, 15).and_hms(2, 0, 0).with_timezone(&FixedOffset::west(1 * 3600));
let later   = Utc.ymd(2015, 5, 15).and_hms(3, 0, 0).with_timezone(&FixedOffset::west(5 * 3600));

assert_eq!(earlier.to_string(), "2015-05-15 01:00:00 -01:00");
assert_eq!(later.to_string(), "2015-05-14 22:00:00 -05:00");

assert!(later > earlier);

#[must_use]

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

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

#[must_use]

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

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

#[must_use]

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

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

#[must_use]

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<Tz> Sub<DateTime<Tz>> for DateTime<Tz> where
    Tz: TimeZone, 

type Output = Duration

The resulting type after applying the - operator.

pub fn sub(self, rhs: DateTime<Tz>) -> Duration

Performs the - operation.

impl<Tz> Sub<Duration> for DateTime<Tz> where
    Tz: TimeZone, 

type Output = DateTime<Tz>

The resulting type after applying the - operator.

pub fn sub(self, rhs: Duration) -> DateTime<Tz>

Performs the - operation.

impl<Tz> Sub<FixedOffset> for DateTime<Tz> where
    Tz: TimeZone, 

type Output = DateTime<Tz>

The resulting type after applying the - operator.

pub fn sub(self, rhs: FixedOffset) -> DateTime<Tz>

Performs the - operation.

impl<Tz> Timelike for DateTime<Tz> where
    Tz: TimeZone, 

pub fn hour(&self) -> u32

Returns the hour number from 0 to 23.

pub fn minute(&self) -> u32

Returns the minute number from 0 to 59.

pub fn second(&self) -> u32

Returns the second number from 0 to 59.

pub fn nanosecond(&self) -> u32

Returns the number of nanoseconds since the whole non-leap second. The range from 1,000,000,000 to 1,999,999,999 represents the leap second.

pub fn with_hour(&self, hour: u32) -> Option<DateTime<Tz>>

Makes a new value with the hour number changed.

pub fn with_minute(&self, min: u32) -> Option<DateTime<Tz>>

Makes a new value with the minute number changed.

pub fn with_second(&self, sec: u32) -> Option<DateTime<Tz>>

Makes a new value with the second number changed.

pub fn with_nanosecond(&self, nano: u32) -> Option<DateTime<Tz>>

Makes a new value with nanoseconds since the whole non-leap second changed.

fn hour12(&self) -> (bool, u32)

Returns the hour number from 1 to 12 with a boolean flag, which is false for AM and true for PM.

fn num_seconds_from_midnight(&self) -> u32

Returns the number of non-leap seconds past the last midnight.

impl Type<MySql> for DateTime<Utc>

pub fn type_info() -> MySqlTypeInfo

Returns the canonical SQL type for this Rust type.

pub fn compatible(ty: &MySqlTypeInfo) -> bool

Determines if this Rust type is compatible with the given SQL type.

impl<Tz> Type<Postgres> for DateTime<Tz> where
    Tz: TimeZone, 

pub fn type_info() -> PgTypeInfo

Returns the canonical SQL type for this Rust type.

fn compatible(ty: &<DB as Database>::TypeInfo) -> bool

Determines if this Rust type is compatible with the given SQL type.

impl<Tz> Type<Sqlite> for DateTime<Tz> where
    Tz: TimeZone, 

pub fn type_info() -> SqliteTypeInfo

Returns the canonical SQL type for this Rust type.

pub fn compatible(ty: &SqliteTypeInfo) -> bool

Determines if this Rust type is compatible with the given SQL type.

impl<Tz> Copy for DateTime<Tz> where
    Tz: TimeZone,
    <Tz as TimeZone>::Offset: Copy, 

impl<Tz> Eq for DateTime<Tz> where
    Tz: TimeZone, 

impl<Tz> Send for DateTime<Tz> where
    Tz: TimeZone,
    <Tz as TimeZone>::Offset: Send,