SQL Data Types

Type Use Size (bytes) Syntax
boolean State of TRUE or FALSE 1 TRUE, FALSE
date Date without a specified time 4 DATE '2007-02-01'
decimal Signed exact number with user-defined precision and scale 16 1.23
float Signed variable-precision, inexact number 8 1.23
int Signed integer 8 123
string Unicode string Variable 'foo'
timestamp Date and time 8 TIMESTAMP '2007-02-01 15:04:05'
timestamptz Date and time with timezone 8 TIMESTAMPTZ '2007-02-01 15:04:05+06'