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
l2_report_time_formats [2019/02/22 15:57]
emozolyak [Duration]
l2_report_time_formats [2022/01/15 06:34] (current)
127.0.0.1 ↷ Links adapted because of a move operation
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.  
-{{ ::time_modifiers.png?direct |}} +Then the special 'token' characters will be looked for to determine how to display the time.  
-Please refer to the below tables:+ 
 +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. 
 + 
 +{{ network:time_modifiers.png?direct |}} 
 +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:  M
 +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".