Data Masker

The Sequential Dates Dataset Form

Any data set that produces formatted dates requires a format string to specify the desired format. Data Masker for SQL Server uses C#'s date formatting strings, while Data Masker for Oracle uses the standard Oracle TO_CHAR date format.

Format Pattern	Description
d, %d	The day of the month. Single-digit days will not have a leading zero. Specify "%d" if the format pattern is not combined with other format patterns.
dd	The day of the month. Single-digit days will have a leading zero.
ddd	The abbreviated name of the day of the week.
dddd	The full name of the day of the week, as defined in DayNames.
M, %M	The numeric month. Single-digit months will not have a leading zero. Specify "%M" if the format pattern is not combined with other format patterns.
MM	The numeric month. Single-digit months will have a leading zero.
MMM	The abbreviated name of the month.
MMMM	The full name of the month.
y, %y	The year without the century. If the year without the century is less than 10, the year is displayed with no leading zero. Specify "%y" if the format pattern is not combined with other format patterns.
yy	The year without the century. If the year without the century is less than 10, the year is displayed with a leading zero.
yyyy	The year in four digits, including the century.
gg	The period or era. This pattern is ignored if the date to be formatted does not have an associated period or era string.
h, %h	The hour in a 12-hour clock. Single-digit hours will not have a leading zero. Specify "%h" if the format pattern is not combined with other format patterns.
hh	The hour in a 12-hour clock. Single-digit hours will have a leading zero.
H, %H	The hour in a 24-hour clock. Single-digit hours will not have a leading zero. Specify "%H" if the format pattern is not combined with other format patterns.
HH	The hour in a 24-hour clock. Single-digit hours will have a leading zero.
m, %m	The minute. Single-digit minutes will not have a leading zero. Specify "%m" if the format pattern is not combined with other format patterns.
mm	The minute. Single-digit minutes will have a leading zero.
s, %s	The second. Single-digit seconds will not have a leading zero. Specify "%s" if the format pattern is not combined with other format patterns.
ss	The second. Single-digit seconds will have a leading zero.
f, %f	The fraction of a second in single-digit precision. The remaining digits are truncated. Specify "%f" if the format pattern is not combined with other format patterns.
ff	The fraction of a second in double-digit precision. The remaining digits are truncated.
fff	The fraction of a second in three-digit precision. The remaining digits are truncated.
ffff	The fraction of a second in four-digit precision. The remaining digits are truncated.
fffff	The fraction of a second in five-digit precision. The remaining digits are truncated.
ffffff	The fraction of a second in six-digit precision. The remaining digits are truncated.
fffffff	The fraction of a second in seven-digit precision. The remaining digits are truncated.
F, %F	Displays the most significant digit of the seconds fraction. Nothing is displayed if the digit is zero. Specify "%F" if the format pattern is not combined with other format patterns.
FF	Displays the two most significant digits of the seconds fraction. However, trailing zeros, or two zero digits, are not displayed.
FFF	Displays the three most significant digits of the seconds fraction. However, trailing zeros, or three zero digits, are not displayed.
FFFF	Displays the four most significant digits of the seconds fraction. However, trailing zeros, or four zero digits, are not displayed.
FFFFF	Displays the five most significant digits of the seconds fraction. However, trailing zeros, or five zero digits, are not displayed.
FFFFFF	Displays the six most significant digits of the seconds fraction. However, trailing zeros, or six zero digits, are not displayed.
FFFFFFF	Displays the seven most significant digits of the seconds fraction. However, trailing zeros, or seven zero digits, are not displayed.
t, %t	The first character in the AM/PM designator. Specify "%t" if the format pattern is not combined with other format patterns.
tt	The AM/PM designator defined in AMDesignator or PMDesignator, if any.
z, %z	The time zone offset ("+" or "-" followed by the hour only). Single-digit hours will not have a leading zero. For example, Pacific Standard Time is "-8". Specify "%z" if the format pattern is not combined with other format patterns.
zz	The time zone offset ("+" or "-" followed by the hour only). Single-digit hours will have a leading zero. For example, Pacific Standard Time is "-08".
zzz	The full time zone offset ("+" or "-" followed by the hour and minutes). Single-digit hours and minutes will have leading zeros. For example, Pacific Standard Time is "-08:00".
:	The default time separator.
/	The default date separator.
% c	Where c is a format pattern if used alone. That is, to use format pattern "d", "f", "F", "h", "m", "s", "t", "y", "z", "H", or "M" by itself, specify "%d", "%f", "%F", "%h", "%m", "%s", "%t", "%y", "%z", "%H", or "%M". The "%" character can be omitted if the format pattern is combined with literal characters or other format patterns.
\ c	Where c is any character. Displays the character literally. To display the backslash character, use "\\".

Element	Description
- / , . ; : "text"	Punctuation and quoted text is reproduced in the result.
AD A.D.	AD indicator with or without periods.
AM A.M.	Meridian indicator with or without periods.
BC B.C.	BC indicator with or without periods.
CC SCC	Century. If the last 2 digits of a 4-digit year are between 01 and 99 (inclusive), then the century is one greater than the first 2 digits of that year. If the last 2 digits of a 4-digit year are 00, then the century is the same as the first 2 digits of that year. For example, 2002 returns 21; 2000 returns 20.
D	Day of week (1-7).
DAY	Name of day, padded with blanks to display width of the widest name of day in the date language used for this element.
DD	Day of month (1-31).
DDD	Day of year (1-366).
	Returns a value in the long date format, which is an extension of Oracle Database's `DATE` format (the current value of the `NLS_DATE_FORMAT` parameter). Makes the appearance of the date components (day name, month number, and so forth) depend on the `NLS_TERRITORY` and `NLS_LANGUAGE` parameters. For example, in the `AMERICAN_AMERICA` locale, this is equivalent to specifying the format `'fmDay,` `Month` `dd,` `yyyy'`. In the `GERMAN_GERMANY` locale, it is equivalent to specifying the format '`fmDay, dd.` `Month yyyy`'. Restriction: You can specify this format only with the `TS` element, separated by white space.
	Returns a value in the short date format. Makes the appearance of the date components (day name, month number, and so forth) depend on the `NLS_TERRITORY` and `NLS_LANGUAGE`parameters. For example, in the `AMERICAN_AMERICA` locale, this is equivalent to specifying the format '`MM/DD/RRRR`'. In the `ENGLISH_UNITED_KINGDOM` locale, it is equivalent to specifying the format '`DD/MM/RRRR`'. Restriction: You can specify this format only with the `TS` element, separated by white space.
DY	Abbreviated name of day.
E	Abbreviated era name (Japanese Imperial, ROC Official, and Thai Buddha calendars).
EE	Full era name (Japanese Imperial, ROC Official, and Thai Buddha calendars).
FF [1..9]	Fractional seconds; no radix character is printed (use the X format element to add the radix character). Use the numbers 1 to 9 after FF to specify the number of digits in the fractional second portion of the datetime value returned. If you do not specify a digit, then Oracle Database uses the precision specified for the datetime datatype or the datatype's default precision. Examples: `'HH:MI:SS.FF'` `SELECT TO_CHAR(SYSTIMESTAMP, 'SS.FF3') from dual;`
FM	Returns a value with no leading or trailing blanks.
FX	Requires exact matching between the character data and the format model.
HH	Hour of day (1-12).
HH12	Hour of day (1-12).
HH24	Hour of day (0-23).
IW	Week of year (1-52 or 1-53) based on the ISO standard.
IYY IY I	Last 3, 2, or 1 digit(s) of ISO year.
IYYY	4-digit year based on the ISO standard.
J	Julian day; the number of days since January 1, 4712 BC. Number specified with J must be integers.
MI	Minute (0-59).
MM	Month (01-12; January = 01).
MON	Abbreviated name of month.
MONTH	Name of month, padded with blanks to display width of the widest name of month in the date language used for this element.
PM P.M.	Meridian indicator with or without periods.
Q	Quarter of year (1, 2, 3, 4; January - March = 1).
RM	Roman numeral month (I-XII; January = I).
RR	Lets you store 20th century dates in the 21st century using only two digits.
RRRR	Round year. Accepts either 4-digit or 2-digit input. If 2-digit, provides the same return as RR. If you do not want this functionality, then enter the 4-digit year.
SS	Second (0-59).
SSSSS	Seconds past midnight (0-86399).
	Returns a value in the short time format. Makes the appearance of the time components (hour, minutes, and so forth) depend on the `NLS_TERRITORY` and `NLS_LANGUAGE` initialization parameters. Restriction: You can specify this format only with the `DL` or `DS` element, separated by white space.
TZD	Daylight savings information. The TZD value is an abbreviated time zone string with daylight savings information. It must correspond with the region specified in TZR. Example: `PST` (for US/Pacific standard time); `PDT` (for US/Pacific daylight time).
TZH	Time zone hour. (See `TZM` format element.) Example: `'HH:MI:SS.FFTZH:TZM'`.
TZM	Time zone minute. (See `TZH` format element.) Example: `'HH:MI:SS.FFTZH:TZM'`.
TZR	Time zone region information. The value must be one of the time zone regions supported in the database. Example: US/Pacific
WW	Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.
W	Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh.
X	Local radix character. Example: `'HH:MI:SSXFF'`.
Y,YYY	Year with comma in this position.
YEAR SYEAR	Year, spelled out; `S` prefixes BC dates with a minus sign (-).
YYYY SYYYY	4-digit year; `S` prefixes BC dates with a minus sign.
YYY YY Y	Last 3, 2, or 1 digit(s) of year.

Data Masker

The formatting codes for the Date-As-Text datasets