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

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
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