...
- If the source Datetime value does not include a valid input for this function, a missing value is returned.
supports a wide variety of formats for Datetime fields. For more information on supported date formats, see Datetime Data Type.D s product r true - You can explore the available Datetime formats through the Transformer page. From a column's type drop-down, select Date/Time . Then, select the formatting category. From the displayed drop-down, you can select a specific format. When this transform step is added to your recipe, you can edit it to see how the format is specified in
.D s lang
...
| D s product |
|---|
| Info |
|---|
NOTE: Two-digit values for the year that are older than 80 years from the current year are forward-ported into the future. For example, in a job run on Dec 31, 2021, the date |
| Info |
|---|
NOTE: If the platform cannot recognize the date format string, the generated result is written as a string value. |
For more information on supported date formats, see Datetime Data Type.
- Missing values for this function in the source data result in missing values in the output.
- Multiple columns and wildcards are not supported.
...
| Source | Transformation | Results | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2/15/16 13:26:58.123 3/12/99 2:45:21.456 11/21/11 23:02:18.000 |
| 1:26:58 PM 2:45:21 AM 11:02:18 PM |
...
| D s also | ||
|---|---|---|
|
