Date, timestamp, and number format strings

See Anaplan Data Orchestrator functions for the types of functions and formats you can use in your column formulas.

Date or Time Part	Description
D	One or two digits day between 1 and 31.
DD	Two digits day between 01 and 31.
DDD	Abbreviated day of the week: Mon, Tue, and so on.
DDDD	Day of the week name: Monday, Tuesday, and so on.
W, WW	One or two digit ISO week number between 1 and 53.
M	One or two digit month between 1 and 12.
MM	Two digit month between 01 and 12.
MMM	Abbreviated month name: Jan, Feb, and so on.
MMMM	Month name: January, February, and so on.
Y, YY, YYY, YYYY	One, two, three, and four digit year.
H, HH	One or two digit hours (24 hours).
h, hh	One or two digit hours (12 hours).
m, mm	One or two digit minutes.
s, ss	One or two digit seconds.
f	Fractions of seconds.
p, P	Lower or uppercase meridian indicators: am, pm, AM, PM.
z	Timezone name: PST (string needs to be cast to timestamp/timestamptz to use timezone format).
Z	Timezone offset: -08:00 (string needs to be cast to timestamp/timestamptz to use timezone format).

Format	Description
9	Numeric value with the specified number of digits.
0	Numeric value with leading zeros.
. (period), D	Decimal point.
, (comma)	Thousands separator.
CC	Century code. For example, the 21st century started on 2001-01-01 (supported for TO_CHAR only).
FM	Fill mode. Suppress padding blanks and zeroes.
PR	Negative value in angle brackets.
S	Sign anchored to a number.
L, $	Currency symbol in the specified position.
G	Group separator.
MI	Minus sign in the specified position for numbers that are less than 0.
PL	Plus sign in the specified position for numbers that are greater than 0.
SG	Plus or minus sign in the specified position.
RN	Roman numeral between 1 and 3999 (supported for TO_CHAR only).
TH or th	Ordinal number suffix. Doesn't convert fractional numbers or values that are less than zero..

Date and timestamp format string