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