l2_report_time_formats
This is an old revision of the document!
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 modifier for them.
Please refer to the below tables:
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) |
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 |
