Difference between revisions of "SDMX Time Formats"

From Fusion Registry Wiki
Jump to navigation Jump to search
(Time Formats)
(Time Formats)
Line 4: Line 4:
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
 
|-
 
|-
! Frequency !! Format !! Example  
+
! Frequency ID !! Frequency !! Format !! Example  
 
|-
 
|-
| Annual || YYYY || 2010
+
| A || Annual || YYYY || 2010
 
|-
 
|-
| Monthly || YYYY-MM || 2010-01
+
| S || Semester (half year) || YYYY-Sn ||2010-S1
 
|-
 
|-
| Daily || YYYY-MM-DD || 2010-01-01
+
| T || Trimester || YYYY-Tn || 2010-T1
 
|-
 
|-
| Date Time || YYYY-MM-DDThh:mm:ss || 2010-01T20:22:00
+
| Q || Quarterly || YYYY-Qn || 2010-Q1
 +
-
 +
| M || Monthly || YYYY-MM || 2010-01
 
|-
 
|-
| Quarterly || YYYY-Qn || 2010-Q1
+
| D || Daily || YYYY-MM-DD || 2010-01-01
 
|-
 
|-
| Semester || YYYY-Sn ||2010-S1
+
| H || Hour || YYYY-MM-DDThh || 2010-01-01T13
 
|-
 
|-
| Trimester || YYYY-Tn || 2010-T1
+
| I || Date Time || YYYY-MM-DDThh:mm:ss || 2010-01T20:22:00
 
|}
 
|}

Revision as of 01:19, 1 April 2022

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