Expand description
DuckDB INTERVAL type conversion utilities.
A DuckDB INTERVAL is a 16-byte struct with three fields:
{ months: i32, days: i32, micros: i64 }Converting to a uniform unit (microseconds) requires careful arithmetic to avoid integer overflow. This module provides checked and saturating conversions.
§Pitfall P8: Undocumented INTERVAL layout
The duckdb_string_t and INTERVAL struct layouts are not documented in the
Rust bindings (libduckdb-sys). They must be inferred from DuckDB’s C headers.
This module encodes that knowledge so extension authors never need to look it up.
§Example
use quack_rs::interval::{interval_to_micros, DuckInterval};
let iv = DuckInterval { months: 1, days: 0, micros: 0 };
// 1 month ≈ 30 days = 2_592_000_000_000 microseconds
assert_eq!(interval_to_micros(iv), Some(2_592_000_000_000_i64));Structs§
- Duck
Interval - A
DuckDBINTERVALvalue, matching the C struct layout exactly.
Constants§
- MICROS_
PER_ DAY - Microseconds per day, used for interval conversion.
- MICROS_
PER_ MONTH - Microseconds per month, approximated as 30 days —
DuckDB’sInterval::MICROS_PER_MONTH, used for comparing intervals (seeinterval_to_microsfor whereDuckDBdoes and does not use it).
Functions§
- interval_
to_ micros - Converts a
DuckIntervalto total microseconds with overflow checking. - interval_
to_ micros_ saturating - Converts a
DuckIntervalto total microseconds, saturating on overflow. - read_
interval_ ⚠at - Reads a
DuckIntervalfrom a rawDuckDBvector data pointer at a given row index.