Date | ScyllaDB Docs

Date¶

Depending on feature flags, three different types can be used to interact with date.

Internally date is represented as number of days since -5877641-06-23 i.e. 2^31 days before unix epoch.

CqlDate¶

Without any extra features enabled, only frame::value::CqlDate is available. It’s an u32 wrapper and it matches the internal date representation.

However, for most use cases other types are more practical. See following sections for chrono and time.

use scylla::frame::value::CqlDate;
use scylla::IntoTypedRows;

// 1970-01-08
let to_insert = CqlDate((1 << 31) + 7);

// Insert date into the table
session
    .query("INSERT INTO keyspace.table (a) VALUES(?)", (to_insert,))
    .await?;

// Read raw Date from the table
if let Some(rows) = session
    .query("SELECT a FROM keyspace.table", &[])
    .await?
    .rows
{
    for row in rows.into_typed::<(CqlDate,)>() {
        let (date_value,): (CqlDate,) = row?;
    }
}

chrono::NaiveDate¶

If full range is not required and chrono feature is enabled, chrono::NaiveDate can be used. chrono::NaiveDate supports dates from -262145-01-01 to 262143-12-31.

use chrono::NaiveDate;
use scylla::IntoTypedRows;

// 2021-03-24
let to_insert = NaiveDate::from_ymd_opt(2021, 3, 24).unwrap();

// Insert date into the table
session
    .query("INSERT INTO keyspace.table (a) VALUES(?)", (to_insert,))
    .await?;

// Read NaiveDate from the table
if let Some(rows) = session
    .query("SELECT a FROM keyspace.table", &[])
    .await?
    .rows
{
    for row in rows.into_typed::<(NaiveDate,)>() {
        let (date_value,): (NaiveDate,) = row?;
    }
}

time::Date¶

Alternatively, time feature can be used to enable support of time::Date. time::Date’s value range depends on feature flags, see its documentation to get more info.

use scylla::IntoTypedRows;
use time::{Date, Month};

// 2021-03-24
let to_insert = Date::from_calendar_date(2021, Month::March, 24).unwrap();

// Insert date into the table
session
    .query("INSERT INTO keyspace.table (a) VALUES(?)", (to_insert,))
    .await?;

// Read Date from the table
if let Some(rows) = session
    .query("SELECT a FROM keyspace.table", &[])
    .await?
    .rows
{
    for row in rows.into_typed::<(Date,)>() {
        let (date_value,): (Date,) = row?;
    }
}

Was this page helpful?