| 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.
| Info |
|---|
NOTE: Date values must be converted to Unix timestamps before applying this function. Unix time measures the number of milliseconds that have elapsed since January 1, 1970 00:00:00 (UTC). See See UNIXTIME Function. |
Supported format strings for this function are the same as the supported format strings for the the DATEFORMAT function. For more information on those string values, see Supported Data Types.
- For more information on formatting Unix or standard date formats, see see DATEFORMAT Function.
- For more For more information on formatting numeric types, see see NUMFORMAT Function.
| D s lang vs sql |
|---|
| D s | ||
|---|---|---|
|
| d-code-lang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| UNIXTIMEFORMAT
|
...
unixtimeformat(MyUnixDate, 'yyyy-MM-dd') |
Output: Returns the Unix timestamp values in the MyUnixDate column, converted to year-month-day format.
| D s | ||
|---|---|---|
|
| d-code-lang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| UNIXTIMEFORMAT
| |||||||||
unixtimeformat(unixtime_col, date_format_string) |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| unixtime_col | Y | datetime | Name of column whose Unix timestamp values are to be formatted |
| date_format_string | Y | string | String literal identifying the date format to apply to the value |
| D s lang notes |
|---|
unixtime_col
...
- Missing values for this function in the source data result in missing values missing values in the output.
- Multiple columns and wildcards are not supported.
D s snippet usage
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | Datetime (formatted as Unix time integer values) | myDate |
...
String value indicating the date format to apply to the input values.
| Info |
|---|
NOTE: If the platform cannot recognize the date format string, the generated result is written as a string value. |
...
- Missing values for this function in the source data result in missing values missing values in the output.
- Multiple columns and wildcards are not supported.
...
| 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 | ||
|---|---|---|
|
