website logo
⌘K
🏠Homepage
👋Introduction
Key Concepts & Architecture
🚀Getting Started
👨‍💻SQL Reference
SQL Queries
SQL Clauses
SQL Data Types
SQL Functions
Schema
🚨Error Handling
🆚Differences Between Oxla vs. PostgreSQL
Docs powered by archbee 

SQL Data Types

1min

While creating a table, you need to specify a data type for each column to define what kind of data you want to store in the table. 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

STRING (i.e., text, longtext, char)

UTF8 encoded string with Unicode support

‘text’

INTEGER

32-bit signed integer

one or more digits "0" to "9"

LONG

64-bit signed integer

large numeric/decimal value

FLOAT

32-bit floating point number

float(n)

DOUBLE

64-bit floating point number

decimal(p, s)

DATE

Date value

YYYY-MM-DD

INTERVAL

Encodes a span of time

year-month (YYYY-MM); day-time (DD HH:MM:SS)

STRING

UTF8 encoded string with Unicode support



TIMESTAMP

Time with microsecond precision.

YYYY-MM-DD [HH:MM:SS[.SSSSSS]]

Time with microsecond precision.

YYYY-MM-DD [HH:MM:SS[.SSSSSS]]

BOOL

Boolean value

True or False

JSON

JSON data type

{"customer":"Dean Smith", "items":{"product:"cup","qty":2}}



Updated 11 May 2023
Did this page help you?
Yes
No
PREVIOUS
OFFSET
NEXT
Data Type Operators
Docs powered by archbee 

Dedicated to data analytics that provides 10x faster execution of analytical queries than current state of the art solutions. We are launching SOON! Join the waiting list for more info.




©2022 Oxla