hours and minutes format mda table

Related products: None
We have usage data formatted in the following format (hours: minutes: seconds), such as 27:44:12. I'd like to hear some suggestions on how an MDA table's Data Type may accommodate that format. We do not have an associated date so we cannot use Date/Time.


Thank you!
We don't currently have a time data type in MDA.  We have Date and DateTime.  Do you have some specific operations you would like to do on this field?  





Two options I can think of for handling today:


1.  String - this should support valid sorting but would restrict filtering


2.  Use DateTime and have a fixed date for all records.





Thanks for posting Mark - We'll take this as an Idea for an enhancement to support Time only data type.
Thank you. We are looking to use this data attribute to perform functions against it (sum, avg, etc) particularly to determine usage patterns and depth. As a result, we cannot use a string format. We could explore using a Date/Time with a fixed date. Thanks. The data, in its current state, fails upon ingestion. Thank you for responding.
Terms & ConditionsCookie settings