...
- Earliest: January 1, 1400
- Latest: December 31, 2599
| Info |
|---|
NOTE: The supported date ranges can be modified if needed. For more information, see Configure Application Limits. |
You can use dates in the Gregorian calendar system only. Dates in the Julian calendar are not supported.
...
| Letter | Date or Time Component | Presentation | Examples | ||
|---|---|---|---|---|---|
| M | Month in year | Number | 1 | ||
| MM | Month in year | Number | 01 | ||
| MMMM | Month in year | Month | January | ||
| MMM | Month in year | Month | Jan | ||
| yy | Year | Number | 16 | ||
| yyyy | Year | Number | 2016 | ||
| D | Day in year | Number | 352 | ||
| d | Day in month | Number | 9 | ||
| dd | Day in a month | Number | 09 | ||
| EEE | Day in week (three-letter abbreviation) | Text | Wed | ||
| EEEE | Day in week | Text | Wednesday | ||
| h | Hour in day (1-12)
| Number | 2 | ||
| hh | Hour in am/pm (01-12)
| Number | 02 | ||
| H | Hour in day (1-12) | Number | 2 | ||
| HH | Hour in day (0-23) | Number | 20 | ||
| m | Minute in an hour | Number | 9 | ||
mm | Minute in an hour | Number | 09 | ||
| s | Second in a minute | Number | 3 | ||
| ss | Second in a minute | Number | 03 | ||
| SSS | Millisecond | Number | 218 | ||
| X | Time zone | ISO 8601 time zone | -08:00 | ||
| a | AM/PM indicator | String | AM |
| Info |
|---|
NOTE: When publishing to relational targets, Datetime values are written as date/time values in newly created tables. If you are appending to a relational table column that is in timestamp format, Datetime values can be written as timestamps. |
| Tip |
|---|
Tip: If your DateTime column contains data in multiple formats, you must change the format of the DateTime column to one format and then add a transform to convert that data to the other format. When all formats of your source date values are converted to a single format, the application should infer the appropriate date and time format. |
...
For more information on supported date formatting strings, see DATEFORMAT Function.
Job Execution
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.
Info 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 as1st Oct, 2020or10th Jan, 2020. Resulting outputs of Datetime values may not be deterministic in this scenario.- Some formatting options may not be supported.
