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. |