supports a variety of Datetime formats, each of which has additional variations to it.
Supported Date Ranges:
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.
When values are validated against the Datetime data type, the does not compare them to an underlying calendar system. Instead, the application validates the values using regular expressions. This regular expression method checks for general Datetime validation and is fast to evaluate.
However, some values may follow the regular expression validation pattern but are not accurate dates. For example, every four years, February 29 is a valid date. When this date is validated against the Datetime data type, it may be detected as a valid value, while the date is changed in the application to be incremented to a close accurate date, such as March 1 in this example.
You can use the following tokens to change the format of a column of dates:
|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|
|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|
Hour in day (1-12)
Hour in am/pm (01-12)
|H||Hour in day (1-12)||Number||2|
|HH||Hour in day (0-23)||Number||20|
|m||Minute in an hour||Number||9|
|Minute in an hour||Number||09|
|s||Second in a minute||Number||3|
|ss||Second in a minute||Number||03|
|X||Time zone||ISO 8601 time zone|
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: 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.
ISO 8601 Time Zone Notes:
Support for timezone offset from UTC indicated by +hh:mm, +hhmm, or +hh. For example, the date '2013-11-18 11:55-04:00' is recognized as a DateTime value.