Query Development | Java Simple Date Format | Teradata Studio/Studio Express - Java Simple Date Format - Teradata Studio

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities
Symbol Definition Example
G Era "GG" → "AD"
y Year
  • "yy" → "033
  • "yyyy" → "20033
M Month
  • "M" → "73
  • "M" → "123
  • "MM" → "December"
d Day in month
  • "d" → "33
  • "dd" → "033
E Day in week
  • "EEE" → "Tue"
  • "EEEE" → "Tuesday"
D Day in year (1-365 or 1-364)
  • "D" → "653
  • "DDD" → "0653
F Day of week in month (1-5) "F" → "13
w Week in year (1-53) "w" → "73
W Week in month (1-5) "W" → "33