Format
You can define a date-time format from within the type properties, except for native schema XML.
The output format for the native schema XML date/time field is always:
{CCYY-MM-DD}T{HH24:MM:SS.3-3+/-ZZ:ZZ}
To specify a different output format,
use Xerces XML instead.To define the Date & Time format:
- Open the type properties.
- In the
The Date Time dialog box is displayed.
property,
click the browse button. - Make your format selections and click OK.
You can use alphabetical characters as separators. In the example, 2001-04-02T10:32:59-0500, T is the separator.
Separators are limited to 60 characters.
Supported date formats:
- CCYYMMDD
- YYMMDD
- MMDDCCYY
- MMDDYY
- CCYYDDD
- YYDDD
- DDMMCCYY
- DDMMYY Note: The DDMMCCYY and DDMMYY formats did not exist prior to version 6.5 of the Design Studio. If you had defined either one of these formats prior to 6.5 as a custom format, it will be recognized in 6.5 as the respective new format, instead of the previously defined custom format.