Difference between revisions of "SDMX Time Formats"
Jump to navigation
Jump to search
(→Time Formats) |
(→Time Formats) |
||
| (4 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 4: | Line 6: | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
|- | |- | ||
| − | ! Frequency !! Format !! Example | + | ! Frequency ID !! Frequency !! Format !! Example |
|- | |- | ||
| − | | Annual || YYYY || 2010 | + | | 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 | ||
|} | |} | ||
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 |
