This section contains description how to use some specialities of informix. It concerns esspecially generation of INTERVAL and DATETIME data types.
INTERVAL and DATETIME types have defined precision similar to NUMERIC type precision. Following table shows examples of UML notation and a result of PSQL generation.
Table A.1. Generaion of INTERVAL and DATETIME in Informix (v1)
| UML Suite notation | SQL script result |
|---|---|
| interval[year][month] | interval year to month |
| interval[minute3][minute] | interval minute(3) to minute |
| interval[day][fraction2] | interval day to fraction(2) |
| interval[day2][fraction3] | interval day(2) to fraction(3) |
| datetime[year][minute] | datetime year to minute |
| datetime[year][fraction2] | datetime year to fraction(2) |
Table A.2. Generaion of INTERVAL and DATETIME in Informix (v2)
| UML Suite notation | SQL script result |
|---|---|
| interval year to month | interval year to month |
| interval minute[3] to minute | interval minute(3) to minute |
| interval day to fraction[2] | interval day to fraction(2) |
| interval day[2] to fraction[3] | interval day(2) to fraction(3) |
| datetime year minute | datetime year to minute |
| datetime year to fraction[2] | datetime year to fraction(2) |