Converts a unix timestamp into a human-readable date/date-time format.
Example 1
Example Input 1
| dim_A | dim_B | Date/Time |
| AAA | DDD | 1546344000 |
| BBB | EEE | 1547569800 |
| CCC | FFF | 1549022400 |
Example Output 1
| dim_A | dim_B | Date/Time |
| AAA | DDD | Jan. 1, 2019, noon |
| BBB | EEE | Jan. 15, 2019, 4:30 p.m. |
| CCC | FFF | Feb. 1, 2019, noon |
Example 2
Example Input 2
| dim_A | dim_B | Date/Time |
| AAA | DDD | 1546344000 |
| BBB | EEE | 1547569800 |
| CCC | FFF | 1549022400 |
Example Output 2
| dim_A | dim_B | Date/Time |
| AAA | DDD | Jan. 1, 2019 |
| BBB | EEE | Jan. 15, 2019 |
| CCC | FFF | Feb. 1, 2019 |
I Ain't Afraid of No Code!
Example 1[
"convertunix",
{
"failonerror": false,
"subtable": null,
"as_date": false,
"fields": [
"Date/Time"
],
"_comment": null
}
][
"convertunix",
{
"failonerror": false,
"subtable": null,
"as_date": true,
"fields": [
"Date/Time"
],
"_comment": null
}
]param boolean failonerror: Default is false.
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param boolean as_date: If true, removes timestamp element.
param str fields: The column fields to be parsed.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.