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:36]
emozolyak
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 ======
  
-===== Hour, minute, second tokens =====+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^ 
 +|L |04/09/1986 |Date (in local format)| 
 +|LL |September 4 1986 |Month name, day of month, year| 
 +|LLL |September 4 1986 8:30 PM |Month name, day of month, year, time| 
 +|LLLL |Thursday, September 4 1986 8:30 PM |Day of week, month name, day of month, year, time| 
 +|LT |08:30 PM |Time (without seconds)| 
 +|LTS |08:30:00 PM |Time (with seconds)| 
 + 
 +==== 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 13: 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".