Aqua Data Studio 15.0.0-dev-96

Build #: 35832

Database:Informix 12.1

 

Description:

 

1. Connect Informix 

 

2. create Table using following script:

 

   CREATE TABLE datetime_datatype ( 

   col_date     DATE NOT NULL,

   col_datetime DATETIME HOUR to MINUTE NOT NULL

    )

   LOCK MODE PAGE

   GO

 

3. Insert the data using following script:

 

   INSERT INTO datetime_datatype(col_date, col_datetime) 

VALUES('2014-2-13', '12:55')

   GO

 

   

4. Now Right click on table datetime_datatype and select Edit Table Data

 

5. we can see that in column col_datetime value is display with default date,it is not display in given formate.

 

6. Now click on Insert Row After icon and double click on col_datetime in that new Row and click on col_date,default value automatically insert in that column and value is not inserted in given formate which we can insert through the query.