---
isPrivate: true
title: DDSQL Editor Data Types (Preview)
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > DDSQL Editor Data Types (Preview)
---

# DDSQL Editor Data Types (Preview)

## Data types{% #data-types %}

DDSQL implements a simplified version of the SQL type system that is mostly descended from PostgreSQL.

### Base types{% #base-types %}

| SQL name  | Aliases                                   | Description                                                    |
| --------- | ----------------------------------------- | -------------------------------------------------------------- |
| integer   | int                                       | Storage is always int64.                                       |
| text      | char, varchar, string                     | Storage is always an unlimited length UTF-8.                   |
| real      | double, decimal                           | Storage is always IEEE-754 float64.                            |
| timestamp | timestamp without time zone               | SQL standard datetime type.                                    |
| date      | Timestamp with resolution on a day level. |
| interval  | Duration of time.                         |
| group     | hstore, tag_column                        | Sorted set of strings with tag-like "= is contains" semantics. |
| boolean   | `TRUE` or `FALSE`                         |
| json      | JSON data                                 |

### Arrays{% #arrays %}

Arrays are an ordered collection of a specific base type. Each base type can have a corresponding array type.

### Literals{% #literals %}

The table below contains examples on how to declare literals for each type, for use in expressions like `SELECT <LITERAL>` or in comparisons like `WHERE timestamp > timestamp '1 hr ago'`.

| Name      | Example                                                                                                                                                     |
| --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
| integer   | `1`, `4`, `23901239412`, `0x4B1D`                                                                                                                           |
| text      | `'Hello, world'`                                                                                                                                            |
| real      | `1.0`, `1e30`, `314e-2`, `.25`, `5.`                                                                                                                        |
| date      | `date <DATE_STRING>` (where `DATE_STRING` is a string that can be parsed into a date, or a relative string like `1 day ago`')                               |
| timestamp | `timestamp <TIMESTAMP_STRING>` (where `TIMESTAMP_STRING` is a string that can be parsed into a timestamp, or a relative string like `'1 day ago'`, `'now'`) |
| interval  | `interval <INTERVAL>` (where `INTERVAL` is a string that can be parsed into a interval, like `1 day`, `30s`, `2 min`')                                      |
| arrays    | `array<type>[values...]`                                                                                                                                    |