User Tools

Site Tools


l2_report_time_formats

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
l2_report_time_formats [2019/02/22 15:48]
emozolyak [Duration]
l2_report_time_formats [2019/02/22 16:26]
emozolyak [Time format modifiers used in Level2 report builder]
Line 1: Line 1:
 ====== Time format modifiers used in Level2 report builder ====== ====== Time format modifiers used in Level2 report builder ======
  
-When you place cells with time values in the report you need to specify format modifier for them. +When you place cells with time values in the report you need to specify format string for them.  
 +Then the special 'token' characters will be looked for to determine how to display the time.  
 + 
 +E.g. in //h:m:s// string for duration h, m and s charachters will be replaced with the duration "weights" in hours, minute and seconds respectively, separated with the ':'. Please refer to the following tables for time and duration format specifiers. 
 {{ ::time_modifiers.png?direct |}} {{ ::time_modifiers.png?direct |}}
-Please refer to the below tables:+Please refer to the below tables for token characters:
  
 ===== Time ===== ===== Time =====
 +
 ==== Locale aware formats ==== ==== Locale aware formats ====
  
Line 31: Line 36:
 |X |1410715640.579 |Unix timestamp| |X |1410715640.579 |Unix timestamp|
 |x |1410715640579 |Unix ms timestamp| |x |1410715640579 |Unix ms timestamp|
-===== Hour, minute, second tokens =====+==== Hour, minute, second tokens ====
  
 ^Input ^Example ^Description^ ^Input ^Example ^Description^
Line 43: Line 48:
 |Z ZZ |+12:00 |Offset from UTC as +-HH:mm, +-HHmm, or Z| |Z ZZ |+12:00 |Offset from UTC as +-HH:mm, +-HHmm, or Z|
  
-===== Duration ======+===== Time duration formatting ====== 
 + 
 +The template string is parsed for moment token characters, which are replaced with the duration's value for each unit type. The moment tokens are: 
 +<code> 
 +years:   Y or y 
 +months: 
 +weeks:   W or w 
 +days:    D or d 
 +hours:   H or h 
 +minutes: m 
 +seconds: s 
 +ms:      S 
 +</code> 
 + 
 +Escape token characters within the template string using square brackets.
  
 +E.g. 
 +<code> h [hrs], m [min] </code> format string will result in such output: "2 hrs, 3 mins".