To format how date and timestamp variables or outputs within a chain should appear, you can apply a Parse Date/Time transformation, and set the value as string format time (strftime).
Date values
| Value |
Example |
strftime |
| Full day name |
Sunday |
%A |
| Abbreviated day name |
Sun |
%a |
| Day of week |
0 to 6, where Sunday is 0 |
%w |
| Two-digit year |
21 |
%y |
| Four-digit year |
2021 |
%Y |
| Full month name |
January |
%B |
| Abbreviated month name |
Jan |
%b |
| Two-digit month |
01 to 12, January to December |
%m |
| Two-digit day of month |
01 to 31 |
%d |
| Day of month with no leading zero |
1 to 31 |
%e |
You can string these values together to set a date format. For example:
| Date format |
Example |
strftime |
| mm/dd/yyyy |
12/01/2021 |
%m/%d/%Y |
| [Full day name], [full month name] [day of month with no leading zero], [four-digit year] |
Wednesday, December 1, 2021 |
%A, %B %e, %Y |
| [Abbreviated month name] [day of month with no leading zero] [abbreviated day name] |
Dec 1 Wed |
%b %e %a |
Time values
| Value |
Example |
strftime |
| Hour of 24-hour clock |
00 to 23 |
%H |
| Hour of 12-hour clock |
01 to 12 |
%I |
| Hour of 12-hour clock with no leading zero |
1 to 12 |
%1 |
| Minute |
00 to 59 |
%M |
| Second |
00 to 60 |
%S |
| Ante or post meridium |
AM or PM |
%p |
| Time zone |
+08 |
%Z |
| Day of year |
001 to 366 |
%m |
| Percent sign |
% |
%% |
You can string these values together to set a time format. For example:
| Date format |
Example |
strftime |
| HH:MM in 24-hour clock |
23:01 |
%H:%M |
| H:MM in 12-hour clock, with ante or post meridium |
4:31 PM |
%1:%M %p |