Supported data types

MySQL

The following data types are supported as user report parameters and in the report's select columns.

Numeric
tinyint
smallint
int
mediumint
bigint
float
double
decimal
year
Date and time
timestamp
date
time
datetime
Character
char
varchar
tinyblob (*)
mediumblob (*)
longblob (*)
blob (*)
tinytext
mediumtext
longtext
text
json

Time data type can be used as normal time or as a duration.

When used as regular time, the column is formatted based on the format defined in the preferences. Normal time has a range of 00:00:00 - 23:59:59.

If you apply a style '%s' to a time column or use aggregate function sum or avg, the time column is then treated as duration, and the format is always H:M:S.

(*) For text data