Difference between revisions of "SDMX Time Formats"
Jump to navigation
Jump to search
(→Time Formats) |
|||
(One intermediate revision by one other user not shown) | |||
Line 1: | Line 1: | ||
+ | [[Category:Concepts_Reference_V10]] | ||
+ | [[Category:Concepts_Reference_V11]] | ||
= Time Formats = | = Time Formats = | ||
− | <p>SDMX has a list of valid representations for time. 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> |
<p>The valid time values are</p> | <p>The valid time values are</p> | ||
{| 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-01T20:22:00 | ||
|} | |} |
Latest revision as of 04:02, 20 July 2023
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-01T20:22:00 |