#database #postgres #postgresql #sql #interval

pg_interval

A native PostgreSQL interval type

5 releases (3 breaking)

0.3.0 May 5, 2019
0.2.0 Apr 1, 2019
0.1.1 Mar 25, 2019
0.1.0 Mar 10, 2019
0.0.1 Aug 6, 2018

#27 in Date and time

39 downloads per month

MIT license

66KB
1.5K SLoC

Build Status codecov

Rust-Postgres-Interval

A interval type for the postgres driver.

Contributing

There is a separate document on how to contribute to this repo here

Overview

Rust-Postgres-Interval is dedicated datatype for the postgres interval type.

extern crate pg_interval;

use pg_interval::Interval;

fn main() {
    let interval = Interval::from_postgres(
        "1 years 1 months 1 days 1 hours"
    ).unwrap();
    let output = interval.to_iso_8601();
    assert_eq!(String::from("P1Y1M1DT1H"), output);
}

Requirements

  • rust 1.22

Roadmap to 1.0.0

  • Convert Interval Into Formated String
    • Iso 8601
    • Postgres
    • Sql
  • Parse Formated Strings Into The Interval Type
    • Iso 8601
    • Postgres
    • Sql
  • Chrono Integrations

Dependencies

~4MB
~70K SLoC