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.
To create your own variation of the DateTime datatype:
-
In the Database painter, create a table
with a DateTime column.For instructions on creating a table, see
the Users Guide. -
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. -
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. -
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.