This table lists the EXPAND ON clause anchor names:
| Anchor Name | Expanding Interval | Default Time Literal | EXPAND Result |
|---|---|---|---|
| ANCHOR_MILLISECOND | INTERVAL ‘1’ MILLISECOND | 00:00:00.000000+00:00 | Each expanded value for the row in the result adjusts the anchor to the nearest millisecond boundary. |
| ANCHOR_SECOND | INTERVAL ‘1’ SECOND | 00:00:00.000000+00:00 | Each expanded value for the row in the result adjusts the anchor to the nearest second boundary. |
| ANCHOR_MINUTE | INTERVAL ‘1’ MINUTE | 00:00:00.000000+00:00 | Each expanded value for the row in the result adjusts the anchor to the nearest minute boundary. |
| ANCHOR_HOUR | INTERVAL ‘1’ HOUR | 00:00:00.000000+00:00 | Each expanded value for the row in the result adjusts the anchor to the nearest hour boundary. |
| WEEK_BEGIN | INTERVAL ‘7’ DAY | 00:00:00.000000+00:00 | Each expanded value for the row in the result has the first day of the corresponding week as its BEGIN bound. |
| WEEK_END | 23:59:59.999999+00:00 | Each expanded value for the row in the result has the last day of the corresponding week as its BEGIN bound. | |
| MONTH_BEGIN | INTERVAL ‘1’ MONTH | 00:00:00.000000+00:00 | Each expanded value for the row in the result has the first day of the corresponding month as its BEGIN bound. |
| MONTH_END | 23:59:59.999999+00:00 | Each expanded value for the row in the result has the last day of the corresponding month as its BEGIN bound. | |
| QUARTER_BEGIN | INTERVAL ‘3’ MONTH | 00:00:00.000000+00:00 | Each expanded value for the row in the result has the first day of the corresponding quarter as its BEGIN bound. |
| QUARTER_END | 23:59:59.999999+00:00 | Each expanded value for the row in the result has the last day of the corresponding quarter as its BEGIN bound. | |
| YEAR_BEGIN | INTERVAL ‘1’ YEAR | 00:00:00.000000+00:00 | Each expanded value for the row in the result has the first day of the corresponding year as its BEGIN bound. |
| YEAR_END | 23:59:59.999999+00:00 | Each expanded value for the row in the result has the last day of the corresponding year as its BEGIN bound. |