Informix DateTime datatype

The DateTime datatype is a contiguous sequence of boxes. Each box represents a component of time that you want to record. The syntax is:

DATETIME largest_qualifier TO smallest_qualifier

PowerBuilder defaults to Year TO Fraction(5).

For a list of qualifiers, see your Informix documentation.

StepsTo create your own variation of the DateTime datatype:

  1. In the Database painter, create a table with a DateTime column.

    For instructions on creating a table, see the Users Guide.

  2. In the Columns view, select Pending Syntax from the Objects or pop-up menu.

    The Columns view displays the pending changes to the table definition. These changes execute only when you click the Save button to save the table definition.

  3. Select Copy from the Edit or pop-up menu or click the Copy button.

    The SQL syntax (or the portion you selected) is copied to the clipboard.

  4. In the ISQL view, modify the DateTime syntax and execute the CREATE TABLE statement.

    For instructions on using the ISQL view, see the Users Guide.