Reference: Date Type

Date is a day-accurate type without time of day references in ISO 8601 YYYY-MM-DD format. CedarDB also accepts PostgreSQL notation.

Usage Example

create table example (
    due_date date
);
insert into example
    values (date '2000-01-01'),
           (date '2000-01-01' + interval '90' day);
select due_date from example;

  due_date
------------
 2000-01-01
 2000-03-31
(2 rows)

Value Range

Storing values outside of the supported range will result in an overflow exception. Operations on dates are range checked, so that e.g., overflows will never cause wrong results.

Input

In a session, you can change the DateStyle setting, which determines the parsing when entering ambiguous dates.

-- The common "little-endian" date style
set DateStyle = 'DMY';
select '01/02/03';

  ?column?  
------------
 2003-02-01
(1 row)

-- US "middle-endian" date style
set DateStyle = 'MDY';
select '01/02/03';

  ?column?  
------------
 2003-01-02
(1 row)