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:
|
1 |
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 section called “Working with tables” in 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 Users Guide.