Bitstring Type
| Name | Aliases | Description |
Blob Type
| Name | Aliases | Description |
Boolean Type
| Name | Aliases | Description |
Date Types
| Name | Aliases | Description |
Enum Types
| Name | Description |
Interval Type
Intervals represent a period of time. This period can be measured in a specific unit or combination of units, for example years, days, or seconds. Intervals are generally used to modify timestamps or dates by either adding or substracting them.
List
List Data Type
Map
Map Data Type
NULL Values
NULL values are special values that are used to represent missing data in SQL. Columns of any type can contain NULL values. Logically, a NULL value can be seen as "the value of this field is unknown".
Numeric Types
Integer Types
Data Types
General-Purpose Data Types
Struct
Struct Data Type
Text Types
In DuckDB, strings can be stored in the VARCHAR field.
Timestamp Type
Timestamps represent points in absolute time, usually called instants.
Time Zones
Time Zone Reference List
Union
Union Data Type