hours and minutes format mda table

  • 1
  • Idea
  • Updated 3 months ago
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!
Photo of Mark Gecsey

Mark Gecsey

  • 484 Points 250 badge 2x thumb

Posted 3 months ago

  • 1
Photo of Denise Stokowski

Denise Stokowski, Official Rep

  • 12,034 Points 10k badge 2x thumb
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.
Photo of Mark Gecsey

Mark Gecsey

  • 484 Points 250 badge 2x thumb
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.