WebDocs Home | Show Navigation Hide Navigation

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 “Data Type Mapping for xfNetLink Java” and “Data Type Mapping for xfNetLink .NET”.

Date storage formats supported by Repository

Format

Definition

YYMMDD

twodigit year, month, day

YYYYMMDD

fourdigit year, month, day

YYJJJ

twodigit year, Julian day

YYYYJJJ

fourdigit year, Julian day

YYPP

twodigit year, period

YYYYPP

fourdigit 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 30character 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

MMDDYYYY

#04

MMDDYY

#05

Mon/DD/YYYY

#06

Mon/DD/YY

#07

MonDDYYYY

#08

MonDDYY

#09

YYYY/MM/DD

#10

YY/MM/DD

#11

YYYYMMDD

#12

YYMMDD

#13

YYYY/Mon/DD

#14

YY/Mon/DD

#15

YYYYMonDD

#16

YYMonDD

#17

DD/MM/YYYY

#18

DD/MM/YY

#19

DDMMYYYY

#20

DDMMYY

#21

DD/Mon/YYYY

#22

DD/Mon/YY

#23

DDMonYYYY

#24

DDMonYY

#25

PP/YYYY

#26

PP/YY

#27

PPYYYY

#28

PPYY

where

MM is the one or twodigit month.

Mon is the threeletter abbreviation for the month.

DD is the one or twodigit 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 twodigit year format for a field that’s stored as a fourdigit 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 12hour notation.

24 is the hour in military (24hour) notation.

MM is the minute.

SS is the second.

m is the meridian a or p (ante or post).