For more information, see Supported Time Zone Values.
Datetime data typing involves the basic type definition, plus any supported formatting options. Depending on where the job is executed, there may be variation in how the Datetime data type is interpreted.
Some running environments may perform additional inference on the typing.
NOTE: During job execution on Spark, inputs of Datetime data type may result in row values being inferred for data type individually. For example, the String value
01/10/2020may be inferred by date transformations as
1st Oct, 2020or
10th Jan, 2020. Resulting outputs of Datetime values may not be deterministic in this scenario.
- Some formatting options may not be supported.