Examples: SELECT WEEK - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Examples of SELECT WEEK usage:

select week(date);
select week(current_date);
select week(date '1900-01-01');
select week(date '1899-12-31');
select week(date '1700-05-31');
select week(date - interval '300' year);
select week(date - interval '6' month);
select week(date - interval '150' day);