Supported datatypes

MySQL

The following data types are supported as user report parameters and in the report 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

Time datatype can be used as regular time or as duration.

When used as regular time, the column is formatted based on the format defined in the preferences. Regular 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