Difference between revisions of "SDMX Time Formats"
Jump to navigation
Jump to search
(→Time Formats) |
(→Time Formats) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[Category:SDMX Structures]] | ||
| + | [[Category:How_To]] | ||
= Time Formats = | = Time Formats = | ||
<p>SDMX has a list of valid representations for time based on the [https://www.iso.org/iso-8601-date-and-time-format.html ISO-8601 standard]. These representaions should be used when reporting time series data, if Frequency is also reported, then the reported frequency should match the reported time value.</p> | <p>SDMX has a list of valid representations for time based on the [https://www.iso.org/iso-8601-date-and-time-format.html ISO-8601 standard]. These representaions should be used when reporting time series data, if Frequency is also reported, then the reported frequency should match the reported time value.</p> | ||
| Line 13: | Line 15: | ||
|- | |- | ||
| Q || Quarterly || YYYY-Qn || 2010-Q1 | | Q || Quarterly || YYYY-Qn || 2010-Q1 | ||
| − | - | + | |- |
| M || Monthly || YYYY-MM || 2010-01 | | M || Monthly || YYYY-MM || 2010-01 | ||
|- | |- | ||
| Line 20: | Line 22: | ||
| H || Hour || YYYY-MM-DDThh || 2010-01-01T13 | | H || Hour || YYYY-MM-DDThh || 2010-01-01T13 | ||
|- | |- | ||
| − | | I || Date Time || YYYY-MM-DDThh:mm:ss || 2010-01T20:22:00 | + | | I || Date Time || YYYY-MM-DDThh:mm:ss || 2010-01-01T20:22:00 |
|} | |} | ||
Latest revision as of 02:30, 22 January 2024
Time Formats
SDMX has a list of valid representations for time based on the ISO-8601 standard. These representaions should be used when reporting time series data, if Frequency is also reported, then the reported frequency should match the reported time value.
The valid time values are
| Frequency ID | Frequency | Format | Example |
|---|---|---|---|
| A | Annual | YYYY | 2010 |
| S | Semester (half year) | YYYY-Sn | 2010-S1 |
| T | Trimester | YYYY-Tn | 2010-T1 |
| Q | Quarterly | YYYY-Qn | 2010-Q1 |
| M | Monthly | YYYY-MM | 2010-01 |
| D | Daily | YYYY-MM-DD | 2010-01-01 |
| H | Hour | YYYY-MM-DDThh | 2010-01-01T13 |
| I | Date Time | YYYY-MM-DDThh:mm:ss | 2010-01-01T20:22:00 |
