17.00 - 17.05 - Date Formats - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Programming Reference
Publication ID
B035-1211-170K
Language
English (United States)
Element Description
CC

SCC

One year greater than the first two digits of a 4-digit year.
  • SYYY
  • YYYY
  • YEAR
  • SYEAR
  • YYY
  • YY
  • Y
Year. Returns a value of 1, the first day of the year.
IYYY

IYY

IY

I

ISO year
MONTH

MON

MM

RM

Month. Returns a value of 1, the first day of the month.
Q Quarter. Returns a value of 1, the first day of the quarter.
WW Same day of the week as the 1st day of the year.
IW Same day of the week as the first day of the ISO year.
W Same day of the week as the first day of the month.
DDD

DD

J

Day.
DAY

DY

D

Starting day of the week.
HH

HH12

HH24

Hour.
MI Minute.