This appendix lists the date and time storage formats supported by Repository and xfODBC, as well as the date and time display formats built into every repository.
Date and time formats selected in Repository also affect how data is converted when a structure is included in a Synergy component (JAR file or assembly). For information on how the various date and time formats are handled by xfNetLink clients, see Appendix B: Data Type Mapping for xfNetLink Java and Appendix C: Data Type Mapping for xfNetLink .NET.
Date storage formats supported by Repository
|
Format |
Definition |
|---|---|
|
YYMMDD |
two-digit year, month, day |
|
YYYYMMDD |
four-digit year, month, day |
|
YYJJJ |
two-digit year, Julian day |
|
YYYYJJJ |
four-digit year, Julian day |
|
YYPP |
two-digit year, period |
|
YYYYPP |
four-digit year, period |
Date storage formats supported by xfODBC
To specify these formats in your repository, define the field as a user type and include the following within the field’s 30-character user data string:
^CLASS^ = format
where format is one of the following:
DDMMYY
DDMMYYYY
MMDDYY
MMDDYYYY
YYYYMMDDHHMISS
YYYYMMDDHHMISSUUUUUU
DDMonYY
DDMonYYYY
MonDDYY
MonDDYYYY
YYMonDD
YYYYMonDD
JJJYY
JJJYYYY
JJJJJJ
PPYY
PPYYYY
Date display formats that are built into every repository
The format name can be seen when you call the DD_FORMAT subroutine in the Repository subroutine library.
|
Format name |
Format |
|---|---|
|
#01 |
MM/DD/YYYY |
|
#02 |
MM/DD/YY |
|
#03 |
MM-DD-YYYY |
|
#04 |
MM-DD-YY |
|
#05 |
Mon/DD/YYYY |
|
#06 |
Mon/DD/YY |
|
#07 |
Mon-DD-YYYY |
|
#08 |
Mon-DD-YY |
|
#09 |
YYYY/MM/DD |
|
#10 |
YY/MM/DD |
|
#11 |
YYYY-MM-DD |
|
#12 |
YY-MM-DD |
|
#13 |
YYYY/Mon/DD |
|
#14 |
YY/Mon/DD |
|
#15 |
YYYY-Mon-DD |
|
#16 |
YY-Mon-DD |
|
#17 |
DD/MM/YYYY |
|
#18 |
DD/MM/YY |
|
#19 |
DD-MM-YYYY |
|
#20 |
DD-MM-YY |
|
#21 |
DD/Mon/YYYY |
|
#22 |
DD/Mon/YY |
|
#23 |
DD-Mon-YYYY |
|
#24 |
DD-Mon-YY |
|
#25 |
PP/YYYY |
|
#26 |
PP/YY |
|
#27 |
PP-YYYY |
|
#28 |
PP-YY |
where
MM is the one- or two-digit month.
Mon is the three-letter abbreviation for the month.
DD is the one- or two-digit day.
YYYY is the year, including the century.
YY is the last two digits of the year.
PP is the period.
The format size and the display size don’t have to match. For example, if you choose a two-digit year format for a field that’s stored as a four-digit year, ReportWriter automatically omits the century from the display format.
Time storage formats supported by Repository
HHMM (hour and minute)
HHMMSS (hour, minute, and second)
Time display formats that are built into every repository
|
Format name |
Format |
|---|---|
|
#01 |
12:MM |
|
#02 |
24:MM |
|
#03 |
12:MMm |
|
#04 |
12:MM:SS |
|
#05 |
24:MM:SS |
|
#06 |
12:MM:SSm |
where
12 is the hour in 12-hour notation.
24 is the hour in military (24-hour) notation.
MM is the minute.
SS is the second.
m is the meridian a or p (ante or post).
