43 (1044 for backward compatibility)

Text Date (YYMMDD)

DATE

6

Text Date in the specified format. Handles years between 1900 and 1999.

44 (1055 for backward compatibility)

Text Date (YYYYMMDD)

DATE

6

Text Date in the specified format.

45 (1050 for backward compatibility)

Text Date (MMDDYY)

DATE

6

Text Date in the specified format. Handles years between 1900 and 1999.

46 (1051 for backward compatibility)

Text Date (MMDDYYYY)

DATE

6

Text Date in the specified format.

47 (1035 for backward compatibility)

Long Date (DDMMYY)

DATE

6

Longword Date in the specified format. Handles years between 1900 and 1999.

48 (1036 for backward compatibility)

Long Date (DDMMYYYY)

DATE

6

Longword Date in the specified format.

49 (1037 for backward compatibility)

Long Date (YYMMDD)

DATE

6

Longword Date in the specified format. Handles years between 1900 and 1999.

50 (1038 for backward compatibility)

Long Date (YYYYMMDD)

DATE

6

Longword Date in the specified format.

51 (1048 for backward compatibility)

Long Date (MMDDYY)

DATE

6

Longword Date in the specified format. Handles years between 1900 and 1999.

52 (1049 for backward compatibility)

Long Date (MMDDYYYY)

DATE

6

Longword Date in the specified format.

53

Pack Date (DDMMYY)

DATE

6

Packed Decimal in the specified format. Handles years between 1900 and 1999.

54

Pack Date (DDMMYYYY)

DATE

6

Packed Decimal in the specified format.

55

Pack Date (YYMMDD)

DATE

6

Packed Decimal in the specified format. Handles years between 1900 and 1999.

56

Pack Date (YYYYMMDD)

DATE

6

Packed Decimal in the specified format.

57

Pack Date (MMDDYY)

DATE

6

Packed Decimal in the specified format. Handles years between 1900 and 1999.

58

Pack Date (MMDDYYYY)

DATE

6

Packed Decimal in the specified format.

59

Text Date 2000 (DDMMYY)

DATE

6

Text Date in the specified format. Handles years between 1941 and 2040.

60

Text Date 2000 (YYMMDD)

DATE

6

Text Date in the specified format. Handles years between 1941 and 2040.

61

Text Date 2000 (MMDDYY)

DATE

6

Text Date in the specified format. Handles years between 1941 and 2040.

62

Long Date 2000 (DDMMYY)

DATE

6

Longword Date in the specified format. Handles years between 1941 and 2040.

63

Long Date 2000 (YYMMDD)

DATE

6

Longword Date in the specified format. Handles years between 1941 and 2040.

64

Long Date 2000 (MMDDYY)

DATE

6

Longword Date in the specified format. Handles years between 1941 and 2040.

65

Pack Date 2000 (DDMMYY)

DATE

6

Packed Decimal Date in the specified format. Handles years between 1900 and 1999.

66

Pack Date 2000 (YYMMDD)

DATE

6

Packed Decimal Date in the specified format. Handles years between 1900 and 1999.

67

Pack Date 2000 (MMDDYY)

DATE

6

Packed Decimal Date in the specified format. Handles years between 1900 and 1999.

68

Maxcim Key Date

DATE

6

Maxcim special key date format.

69 (1046 for backward compatibility)

Text Currency

CURRENCY

21

Numeric money value stored as ASCII text with implied decimal point.

70 (1031 for backward compatibility)

Word -> Currency

CURRENCY

21

DECODBC Word

The Word Currency data type is identical to the Word Decimal data type, except the data is converted to a SQL Decimal instead of a SQL Double. This may provide greater precision.

71 (1032 for backward compatibility)

Longword Currency

CURRENCY

21

72 (1033 for backward compatibility)

Quadword -> Currency

CURRENCY

21

DEC ODBC Quadword

The Quadword Currency data type is identical to the Quadword Decimal data type, except the data is converted to a SQL Decimal instead of a SQL Double. This may provide greater precision.

73 (1047 for backward compatibility)

Packed Decimal -> Currency

CURRENCY

21

The Packed Decimal Currency data type is identical to the Packed Decimal data type, except the data is converted to a SQL Decimal instead of a SQL Double. This may provide greater precision.

74

VMS 4 Byte Date

DATE

6

VMS Date with truncated Time value.

75

Reverse VMS 4 Byte Date

DATE

6

VMS 4-byte Date with bytes reversed.

76

CODA Year

SMALLINT

2

Word, a year is represented in a number offset from the year 1900. A value of 50 would represent 1950, and a value of 103 would represent the year 2003.

77

Reverse CODA Year

SMALLINT

2

Coda Year with bytes reversed.

78

BMS Date

DATE

6

3-byte Date for BMS.

79

BMS Reverse Date

DATE

6

3-byte Reverse Date for BMS.