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