Time type

Describes the Time type properties. Time type has properties such as Byte order, Character Set, Default, Data Format, Format string, and Is midnight seconds.

  • Byte order. Specifies how multiple byte data types are ordered. Choose from:
    • little-endian. The high byte is on the right.
    • big-endian. The high byte is on the left.
    • native-endian. As defined by the native format of the machine.
  • Character Set. Choose from ASCII or EBCDIC.
  • Default. The default value for a column. This is used for data written by a Generate stage. It also supplies the value to substitute for a column that causes an error (whether written or read).
  • Data Format. Specifies the data representation format of a column. Choose from:
    • binary
    • text

      For time, binary is equivalent to midnight_seconds, text specifies that the field represents time in the text-based form %hh:%nn:%ss or in the default date format if you have defined a new one on an NLS system.

  • Format string. Specifies the format of columns representing time as a string. By default this is %hh-%mm-%ss. For details about the format, see Time formats
  • Is midnight seconds. Select this to specify that times are written as a binary 32-bit integer containing the number of seconds elapsed from the previous midnight.