LucidDbDateFormat
From LucidDB Wiki
Java conventions for date format string
LucidDb will follow the formatting conventions used by java.text.SimpleDateFormat which are as follows:
| Field | Full Form | Short Form |
|---|---|---|
| Year | yyyy (4 digits) | yy (2 digits) |
| Month | MMM (name) | MM (2 digits), M (1 or 2 digits) |
| Day of week | EEEE | EE |
| Day of month | dd (2 digits) | d (1 or 2 digits) |
| Hour (1-12) | hh (2 digits) | h (1 or 2 digits) |
| Hour (0-23) | HH (2 digits) | H (1 or 2 digits) |
| Hour (0-11) | KK | K |
| Hour (1-24) | kk | k |
| Minute | mm | |
| Second | ss | |
| Millisecond | SSS | |
| AM/PM | a | |
| Time zone | zzzz | zz |
| Day of week in month | F (e.g., 3rd Thursday) | |
| Day in year | DDD (3 digits | D (1, 2, or 3 digits) |
| Week in year | ww | |
| Era (BC/AD) | G |
