Appendix B: Date and Time Formats

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).