Anchor Names - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™
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.