finops-toolkit icon indicating copy to clipboard operation
finops-toolkit copied to clipboard

[Cost Management] FOCUS datasets do not include seconds in dates

Open flanakin opened this issue 5 months ago â€ĸ 0 comments

🐛 Problem

FOCUS date columns are formatted without seconds when they should include seconds.

Actual/Expected Value
Actual yyyy-MM-ddTHH:mmZ
Expected yyyy-MM-ddTHH:mm:ssZ

This impacts the following columns:

  • BillingPeriodStart/End
  • ChargePeriodStart/End
  • x_BillingExchangeRateDate
  • x_ServicePeriodStart/End

đŸ‘Ŗ Repro steps

  1. Export FOCUS cost details (any version)
  2. Review any of the date columns
  3. Note they are missing the seconds

🤔 Expected

All dates should be formatted with seconds (yyyy-MM-ddTHH:mm:ssZ).

ℹī¸ Additional context

Wikipedia says that seconds are optional. We need to confirm with the actual ISO 8601 specification.

Regardless, we have received a report that not having seconds is breaking parsing in some database engines. Due to this, the Cost Management team is working on a fix.

🙋‍♀ī¸ Ask for the community

We could use your help:

  1. Please vote this issue up (👍) to prioritize it.
  2. Leave comments to help us solidify the vision.

flanakin avatar Sep 10 '24 18:09 flanakin