Data Transformation Engine Functions and Expressions Reference Guide

Appendix B - Format Strings Date and Time Format Strings
Functions and Expressions Reference Guide
241
Date Units
Symbol Description
CCYY Full year including century (2001)
YY Last two digits of the year (00-99)
MM Month of the year in two numeric digits (01-12)
M Month of the year in one or two numeric digits as needed (1 to
12)
MON First three letters of the month (Jan to Dec)
MONTH Full name of the month (January to December)
DDD Day of the year in three numeric digits (001 to 366)
DD Day of the month in two numeric digits (01 to 31)
D Day of the month in one or two numeric digits as needed (1 to
31)
DY First three letters of the weekday (Sun to Sat)
DAY Full name of the weekday (Sunday to Saturday)
WW Week of year (1-52)
Qn Quarter of the year (Q1-Q4)
EEYY Emperor’s year, long form
EY Emperor’s year, short form