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:38]
emozolyak [Hour, minute, second tokens]
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 ======
  
-===== Locale aware formats =====+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. 
 + 
 +{{ network:time_modifiers.png?direct |}} 
 +Please refer to the below tables for token characters: 
 + 
 +===== Time ===== 
 + 
 +==== Locale aware formats ==== 
  
 ^Input ^Example ^Description^ ^Input ^Example ^Description^
Line 11: Line 22:
 |LTS |08:30:00 PM |Time (with seconds)| |LTS |08:30:00 PM |Time (with seconds)|
  
-===== Hour, minute, second tokens =====+==== Year, month, and day tokens =====  
 + 
 +^Input ^Example ^Description^ 
 +|YYYY |2014 |4 or 2 digit year| 
 +|YY |14 |2 digit year| 
 +|Y |-25 |Year with any number of digits and sign| 
 +|Q |1..4 |Quarter of year. Sets month to first month in quarter.| 
 +|M MM |1..12 Month number| 
 +|MMM MMMM |Jan..December |Month name in locale set | 
 +|D DD 1..31 Day of month| 
 +|Do |1st..31st |Day of month with ordinal| 
 +|DDD DDDD |1..365 |Day of year| 
 +|X |1410715640.579 |Unix timestamp| 
 +|x |1410715640579 |Unix ms timestamp| 
 +==== Hour, minute, second tokens ====
  
 ^Input ^Example ^Description^ ^Input ^Example ^Description^
Line 23: 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|
  
 +===== 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".