# Date and Time Type

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 Database terms at this level](https://www.ask-codey.com/glossary/subjects/database/apprentice)

Updated: September 27, 2026

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