Miscellaneous Datatypes

Datetime

Date

• stored in YYYY-MM-DD

Time

• stored in HH:MM:SS

Timestamp

• stored in YYYY-MM-DD HH:MM:SS

Interval

* an interval between two timestamps

Large Entries

Blob

• binary large object - a large collection of uninterpreted binary data

Clob

• character large object - a humongous string

both of these return a pointer to the data

---

User-Defined Types

CREATE TYPE dollars AS numeric (12,2) FINAL

creates a type dollars which can be used in other queries

---

Domains

• domains are like types that can have constraints

CREATE DOMAIN degree_level VARCHAR(10) 
    CONSTRAINT degree_level_test 
        CHECK (value in ('Bachelors', 'Masters', 'Doctorate'))