Date Formats - Advanced SQL Engine - Teradata Database

SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dzx1591742169550.ditamap
dita:ditavalPath
dzx1591742169550.ditaval
dita:id
B035-1211
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.