D toc |
---|
Excerpt |
---|
Formats a set of Unix timestamps according to a specified date formatting string. |
Source values can be a reference to a column containing Unix timestamp values.
...
Description | unixTimestamp column | Transform | newUnixTimestamp column | ||||
---|---|---|---|---|---|---|---|
Numeric date, year first | 1454946120000 1451433600000 1430032020000 |
| 2016-02-08 2015-12-30 2015-04-26 | ||||
Numeric date, American style | 1454946120000 1451433600000 1430032020000 |
| 2/8/16 12/30/15 4/26/15 | ||||
Full written date | 1454946120000 1451433600000 1430032020000 |
| February 08, 2016 December 30, 2015 April 26, 2015 | ||||
Abbreviated date, including abbreviated day of week | 1454946120000 1451433600000 1430032020000 |
| Mon Feb 08, 2016 Wed Dec 30, 2015 Sun Apr 26, 2015 | ||||
Full 24-hour time | 1454946120000 1451433600000 1430032020000 |
| 15:42:00.000 00:00:00.000 07:07:00.00 | ||||
Twelve-hour time with AM/PM indicator | 1454946120000 1451433600000 1430032020000 |
| 3:42:00 PM 12:00:00 AM 7:07:00 AM |
D s also | ||
---|---|---|
|