l2_report_time_formats
Table of Contents
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
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:
years: Y or y months: M weeks: W or w days: D or d hours: H or h minutes: m seconds: s ms: S
Escape token characters within the template string using square brackets.
E.g.
h [hrs], m [min]
format string will result in such output: “2 hrs, 3 mins”.
l2_report_time_formats.txt · Last modified: 2022/01/15 06:34 by 127.0.0.1