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 |
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