l2_report_time_formats
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
l2_report_time_formats [2019/02/22 15:36] – emozolyak | l2_report_time_formats [2022/01/15 06:34] (current) – ↷ Links adapted because of a move operation 127.0.0.1 | ||
---|---|---|---|
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 ' | ||
+ | |||
+ | E.g. in //h:m:s// string for duration h, m and s charachters will be replaced with the duration " | ||
+ | |||
+ | {{ network: | ||
+ | Please refer to the below tables for token characters: | ||
+ | |||
+ | ===== Time ===== | ||
+ | |||
+ | ==== Locale aware formats ==== | ||
+ | |||
+ | |||
+ | ^Input ^Example ^Description^ | ||
+ | |L |04/ | ||
+ | |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, | ||
+ | |LT |08:30 PM |Time (without seconds)| | ||
+ | |LTS |08: | ||
+ | |||
+ | ==== 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: | |Z ZZ |+12: | ||
+ | ===== Time duration formatting ====== | ||
+ | |||
+ | The template string is parsed for moment token characters, which are replaced with the duration' | ||
+ | < | ||
+ | years: | ||
+ | months: | ||
+ | weeks: | ||
+ | days: D or d | ||
+ | hours: | ||
+ | minutes: m | ||
+ | seconds: s | ||
+ | ms: S | ||
+ | </ | ||
+ | |||
+ | Escape token characters within the template string using square brackets. | ||
+ | |||
+ | E.g. | ||
+ | < |
l2_report_time_formats.txt · Last modified: 2022/01/15 06:34 by 127.0.0.1