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