# Date and Time Type

say it: **“DAYT and TYM TYP”** **/ˈdeɪt ænd taɪm taɪp/**

A SQL type representing a date, time, timestamp, or interval.

## What is **Date and Time Type** in a relational database?

**Date and Time Type** — A SQL type representing a date, time, timestamp, or interval.

```sql
CREATE TABLE appointment (
    starts_at TIMESTAMP NOT NULL
);
```

Level: Apprentice · [More SQL terms at this level](https://www.ask-codey.com/glossary?category=sql&level=2)

Updated: November 17, 2026

Source: https://www.ask-codey.com/glossary/date-and-time-type
