CONNX Data Types - Marc BIB Decimal to Timestamp14

Marc BIB Decimal

381

DECIMAL

-1

Customer-specific base 240 number conversion

Marc BIB Number

339

LONG

-1

Marc BIB Tag

382

LONG

-1

Customer-specific base 240 number conversion

MAXCIM Key Date

68

DATE

4

Maxcim special key date format.

MG Word Date

408

DATE

2

Morse Date

154

DATE

4

Custom Data Type for Morse Data

Naftha Text

439

Char

-1

National Compressed -> Decimal

321

DECIMAL

-1

Customer-specific numeric to SQL Decimal

National Compressed Double

118

DOUBLE

-1

Compressed double data type.

Noah Date

80

DATE

4

Site-specific.

Noah Inverse Date

81

DATE

4

Site-specific.

Noah Time

82

TIME

4

Site-specific.

Numeric Data (YYMMDD)

385

DATE

3

Three-byte data field were date is taken from the decimal digits of the values. Thus a numeric value of 750824 is interpreted as August 24 1975. Note that the year field uses a century window where values < 25 are assigned century 2000, everything else 1900. The new function is far more customer specific: TPADateOfBirth (date, centuryCode)
Inputs:
date - base birth date, for example a field of Numeric Date type.

centuryCode - integer value indicating century of birth, 8 = 1800, 9 = 1900, 0 == 2000, no other valid values.

Opus Date

424

DATE

6

Opus Date Packed

425

DATE

3

Pack Date (DDMMYY)

53

DATE

4

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

Pack Date (DDMMYYYY)

54

DATE

5

Packed Decimal in the specified format.

Pack Date (MMDDYY)

57

DATE

4

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

Pack Date (MMDDYYYY)

58

DATE

5

Packed Decimal in the specified format.

Pack Date (YYMMDD)

55

DATE

4

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

Pack Date (YYYYMMDD)

56

DATE

5

Packed Decimal in the specified format.

Pack Date 2000 (DDMMYY)

65

DATE

4

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

Pack Date 2000 (MMDDYY)

67

DATE

4

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

Pack Date 2000 (YYMMDD)

66

DATE

4

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

Packed (A) Decimal -> Decimal

316

DECIMAL

-1

Packed decimal to SQL Decimal, value of 'A' denotes negative

PACKED (A) Decimal -> Double

100

DOUBLE

-1

Packed Decimal of type (A)

PACKED (A) Decimal -> Int

101

LONG

-1

Packed Decimal of type (A)

Packed (E) Decimal -> Decimal

317

DECIMAL

-1

Packed decimal to SQL Decimal, value of 'E' denotes negative

PACKED (E) Decimal -> Double

102

DOUBLE

-1

Packed Decimal of type (E)

PACKED (E) Decimal -> Int

103

LONG

-1

Packed Decimal of type (E)

Packed (F) Decimal -> Decimal

318

DECIMAL

-1

Packed decimal to SQL Decimal, value of 'E' denotes negative

PACKED (F) Decimal -> Double

104

DOUBLE

-1

Packed Decimal of type (F)

PACKED (F) Decimal -> Int

105

LONG

-1

Packed Decimal of type (F)

Packed Decimal -> Decimal

314

DECIMAL

-1

Packed decimal converts to SQL Decimal

Packed Decimal COMP6 -> Double

224

DOUBLE

-1

VMS Packed Decimal

PIC S9(X1)V9(X2) COMP-3

Packed Decimal (1-255 bytes) converts to a double precision floating point; same as Packed Decimal (Double) but unsigned.

Packed Decimal COMP6 -> Decimal

325

DECIMAL

-1

Unsigned packed decimal to SQL Decimal

Packed Decimal COMP6 -> Integer

225

LONG

-1

VMS Packed Decimal

PIC S9(X1)V9(X2) COMP-3

Packed Decimal (1-255 bytes) converts to a long; same as Packed Decimal (Integer) but unsigned.

Packed Decimal -> Currency

73 (1047 for backward compatibility.)

CURRENCY

-1

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.

Packed Decimal -> Double

22 (1014 with fraction > 0 for backward compatibility.)

DOUBLE

-1

VMS Packed Decimal

PIC S9(X1)V9(X2) COMP-3

Packed Decimal (1-255 bytes) converts to a double precision floating point.

Packed Decimal -> Integer

23 (1014 with fraction = 0 for backward compatibility.)

LONG

-1

VMS Packed Decimal

PIC S9(X1)V9(X2) COMP-3

Packed Decimal (1-255 bytes) converts to a long.

Pinnacle Date

283

DATE

6

PioTech Date

443

SQL_DATE

6

PioTech Numeric

442

SQL_BIGINT

4

Pk Centry Date (CYYMMDD)

249

DATE

4

POISE Double

95

DOUBLE

-1

ASCII double left space padded with explicit decimal point and sign.

POISE Double (Right Padded)

259

DOUBLE

-1

ASCII double right space padded with explicit decimal point and sign.
Used to convert the data type in POISE RMS key field(s).

POISE Julian Date

260

DATE

2

2 byte, Julian format (1 = 01/01/1970)

POISE Record Number

247

INTEGER

4

None

A special data type used only in the record field of any POISE key file.

POISE Text Date (MMDDYYYY)

258

DATE

8

POISE Text date in the specified format.

POISE Text Date 2000 (MMDDYY)

257

DATE

6

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

POISE Time

261

TIME

2

2 byte field contains minutes after midnight.

POISE Txt (Right Pad) -> Decimal

324

DECIMAL

-1

Customer-specific character to SQL Decimal

POISE Validate Code

248

VARCHAR

-1

None

A short code descriptor is populated in the CDD comment field. When the field is displayed using CONNX, the code descriptor prefixes the data value.

PostgreSQL Numeric -> Decimal

406

DECIMAL

-1

PROMIS Timesetamp

418

TIMESTAMP

4

Quadword -> Char

15

CHAR

8

Quadword -> Char (DP)

16

CHAR

8

Quadword -> Currency

72 (1033 for backward compatibility.)

CURRENCY

8

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.

Quadword -> Decimal

312

DECIMAL

8

Four-byte signed value converts to a SQL Decimal

Quadword -> Double

171

DOUBLE

8

VMS Quadword Integer with implied decimal

PIC S9(X1)V9(X2) COMP

where X1+X2 is between 10 and 20.

Quadword Integer with an implied decimal place (8 bytes) converts to a SQL Double.

Quadword -> Char

15 (1029 for backward compatibility.)

VARCHAR

8

VMS Quadword Integer

PIC S9(X1)V9(X2) COMP

where X1+X2 is between 10 and 20.

Quadword Integer (8 bytes) converts to a SQL String.

Quadword (BE) -> Char

284

VARCHAR

8

Rev Encapsulated Date (MMDDcy)

389

SQL_DATE

6

Byte 0 -> binary number representing the most significant two digits of a four digit year.

Byte 1 -> binary number representing the least significant two digits of a four digit year.

Thus, if given the first two bytes values of 20, 03, the year for this date are 2003.

 Bytes 2 & 3 are the numeric characters representing the month of the year. Bytes 4 & 5 are the numeric characters representing the day of the month. Thus a value of 0x010131313131 is a date of November (month 11) 11 (day 11) in the year 101.

Reverse CODA Year

77

SMALLINT

2

Coda Year with bytes reversed.

Reverse Long Date YYYYMMDD

245

DATE

4

Subtracts 100000000 from the date, stored physically as a Long, yielding numbers that, if sorted, result in dates in descending order.

Reverse Text Date YYYYMMDD

244

DATE

8

Subtracts 100000000 from the date, stored physically as a Long, yielding numbers that, if sorted, result in dates in descending order.

Reverse VMS 4 Byte Date

75

DATE

4

VMS 4-byte date with bytes reversed.

Reverse VMS Date

30

DATE

8

Maxcim Date

VMS Binary Date/Time (8 Bytes) converts to an ODBC Date. All bytes are stored in reverse order.

Reverse VMS Date/Time

32

TIMESTAMP

8

VMS Binary Date/Time (8 bytes) converts to an ODBC Timestamp. All bytes are stored in reverse order.

Reverse VMS Time

31

TIME

8

VMS Binary Date/Time (8 bytes) converts to an ODBC Time. All bytes are stored in reverse order.

Reverse VMS Date (6 byte)

157

DATE

6

Reversed VMS Date stored in 6 bytes (fractional second precision is truncated).

Right Separate -> Decimal

320

DECIMAL

-1

Character to SQL Decimal with trailing sign

Right Separate -> Double

112

DOUBLE

-1

Right Separate

Right Separate Double

Right Separate -> Integer

113

LONG

-1

Right Separate

Right Separate Integer

Signed Overpunch -> Decimal

315

DECIMAL

-1

Overpunched decimal converts to SQL Decimal

Signed Overpunch -> Double

24 (1011 with fraction > 0 for backward compatibility.)

DOUBLE

-1

VMS Numeric String left overpunched sign

Signed Overpunch (1-255 digits) converts to a double precision floating point.

Signed Overpunch -> Integer

25 (1011 with fraction = 0 for backward compatibility.)

LONG

-1

VMS Numeric String left overpunched sign

Signed Overpunch (1-255 digits) converts to a long

Text -> Decimal

332

DECIMAL

-1

Character to SQL Decimal

Text -> Double

18

DOUBLE

-1

Text -> Integer

17

INTEGER

-1

Text (Expandable)

3

VARCHAR

-1

Alphanumeric and symbols. (1-30000 chars).

Text (Formatted) -> Double

19

DOUBLE

-1

Text (Null Terminated)

2

VARCHAR

-1

Text (Nullable) -> Double

254

DOUBLE

-1

Text (Nullable) -> Integer

253

INTEGER

-1

Text (Left Space Padded)

228

CHAR

1-30000

Text

Maxcim Yes/No

Alphanumeric and symbols. (1-30000 chars); same as Text but with left space padding.

Text (Right Space Padded)

1 (1000 for backward compatibility.)

CHAR

1-30000

Text

Maxcim Yes/No

Alphanumeric and symbols. (1-30000 chars); same as Text but with right space padding.

Text Currency

69 (1046 for backward compatibility.)

CURRENCY

1-20

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

Text Date (DD)

399

DATE

2

For DD, if DD = 30, the SQL date would be January 30, 2003. The year returned is the current year. The month is always January.

Text Date (DDMMYY)

41 (1042 for backward compatibility.)

DATE

6

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

Text Date (DDMMYYYY)

42 (1043 for backward compatibility.)

DATE

8

Text Date in the specified format.

Text Date (MM)

398

DATE

2

For MM, if MM was 11, the SQL date would be November 1, 2003. The year returned is the current year. The day of the month is always one.

Text Date (MMDDYY)

45 (1050 for backward compatibility.)

DATE

6

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

Text Date (MMDDYYYY)

46 (1051 for backward compatibility.)

DATE

8

Text Date in the specified format.

Text Date (MMYYYY)

394

DATE

6

For MMYYYY, if MMYYYY was 032002, the SQL date would be March 1, 2003. The day of the month is always one (1).

Text Date (YYMMDD)   

43(1044 for backward compatibility.)

DATE

6

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

Text Date (YYYY)

396

DATE

4

For YYYY, if YYYY was 2004, the SQL date would be January 1, 2004. The day of the month is always one (1). The month is always January.

Text Date (YYYYMM)

392

DATE

6

For YYYYMM, if YYYYMM was 200203, the SQL date would be March 1, 2003. The day of the month is always one (1).

Text Date (YYYYMMDD)

44 (1055 for backward compatibility.)

DATE

8

Text Date in the specified format.

Text Date 2000 (DDMMYY)

59

DATE

6

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

Text Date 2000 (MMDDYY)

60

DATE

6

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

Text Date 2000 (MMYY)

395

DATE

4

For MMYY, if MMYY was 0403, the SQL date would be April 1, 2003. The day of the month is always one (1).

For MMYY, if MMYY was 0423, the SQL date would be April 1, 1923. The day of the month is always one (1).

The break year = 20 (For years below 20.., add 2000; years above 20, add 1900. Tthe break year is configurable.)

Text Date 2000 (YY)

397

DATE

2

For YY, if YY was 4, the SQL date would be January 1, 2004. The day of the months is always one. The month is always January.

For YY, if YY was 34, the SQL date would be January 1, 1934. The day of the months is always one. The months is always January.

The break year = 20 (For years below 20.., add 2000; years above 20, add 1900. Tthe break year is configurable.)

Text Date 2000 (YYMM)

393

DATE

4

For YYMM, if YYMM was 0304, the SQL date would be April 1, 2003. The day of the month is always one (1). For YYMM, if YYMM was 2304, the SQL date would be April 1, 1923. The day of the month is always one (1).

The break year = 20 (For years below 20.., add 2000; years above 20, add 1900. Tthe break year is configurable.)

Text Date 2000 (YYMMDD)

61

DATE

6

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

Text Left Space Pad -> Dbl

228

DOUBLE

-1

Text (Formatted) -> Double

19

DOUBLE

-1

Text Left Space Pad -> FmtDbl

298

DOUBLE

-1

Text Left Space Pad -> Int

227

INTEGER

-1

Text (Space Padded) No Nulls

218

CHAR

-1

Time (Text HHMM)

281

TIME

4

Time (Text HHMMSS)

282

TIME

6

Timestamp12 (YYYYMMDDHHMM)

353

TIMESTAMP

12

Character Timestamp with year, month, day, hour, and minute

Timestamp14 (YYYYMMDDHHMMSS)

354

TIMESTAMP

14

Character Timestamp with year, month, day, hour, minute, and second