Differences

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

--- l2_report_time_formats [2019/02/22 15:31] – created emozolyak
+++ l2_report_time_formats [2019/02/22 16:26] – [Time format modifiers used in Level2 report builder] emozolyak
@@ Line 1: / Line 1: @@
 ====== Time format modifiers used in Level2 report builder ======
+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 |}}
+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^
+|H HH	|0..23	|Hours (24 hour time)|
+|h hh	|1..12	|Hours (12 hour time used with a A.)|
+|k kk	|1..24	|Hours (24 hour time from 1 to 24)|
+|a A	|am pm	|Post or ante meridiem (Note the one character a p are also considered valid)|
+|m mm	|0..59	|Minutes|
+|s ss	|0..59	|Seconds|
+|S SS SSS|	0..999	|Fractional seconds|
+|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".