Calendar Differences - Advanced SQL Engine - Teradata Database

SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
xmd1556127764262.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1211
lifecycle
previous
Product Category
Teradata Vantageā„¢
For This Calendar... The First Full Week Begins...
Teradata on Sunday.

The days of the year before Sunday belong to Week 0.

For example, if the year starts on January 1, 2004 (a Thursday), then Week 0 is from January 1 to January 3. Week 1 begins on Sunday, January 4.

ISO on Monday.

The first week of the year is the first week that has at least 4 days. If a week has fewer than 4 days, it belongs to the last week of the previous year. There are no partial weeks.

This calendar follows the ISO and European standard. For example, if the year starts on January 1, 2008 (a Tuesday) and the week start is Monday, week 1 of 2008 is from December 31, 2007, to January 6, 2008.

COMPATIBLE on January 1. regardless of what day of the week that is.

There can be partial weeks with 1 day (for most years) or 2 days (for leap years) at the end of the year. The day the week begins can change from year to year.

This calendar is Oracle-compatible. For example, if January 1, 2011, is a Saturday, the first week of the year is from Saturday, January 1, 2011, through Friday, January 7, 2011.