Overview

While creating a table, you need to specify a data type for each column to define what kind of data you want to store. This section will look into the various data types supported in Oxla. Now, let’s get an overview of each data type:

Data Types	Definition	Format
BOOL	Boolean value.	True or False.
TEXT	UTF8 encoded string with Unicode support.	‘text’
DATE	Date value.	YYYY-MM-DD
TIMESTAMP WITHOUT TIME ZONE	Time and date values without a time zone.	YYYY-MM-DD [HH:MM:SS[.SSSSSS]]
TIMESTAMP WITH TIME ZONE	Date and time values, including the time zone information.	YYYY-MM-DD HH:MM:SS.SSSSSS+TZ
TIME	Time values without any date information.	HH:MM:SS[.SSSSSS]
JSON	A value in JSON standard format.	variable_name JSON
INTERVAL	Encodes a span of time	year-month (YYYY-MM); day-time (DD HH:MM:SS)
INT	32-bit signed integer	one or more digits “0” to “9”
BIGINT	64-bit signed integer	large numeric/decimal value
REAL	32-bit floating point number	float(n)
DOUBLE PRECISION	64-bit floating point number	decimal(p, s)