2. Language Elements : Data Types : Date/Time Data Types : Coercion Between Date/Time Data Types
 
Share this page                  
Coercion Between Date/Time Data Types
OpenROAD 6.0 supports the Ingres DATE (INGRESDATE or DATE) data type. OpenROAD Runtime supports coercion of various Ingres ANSI INTERVAL, ANSI TIME, ANSI DATE, and ANSI TIMESTAMP columns into OpenROAD variables declared as DATE. OpenROAD can select, update, and insert INGRESDATE, ANSI DATE, ANSI TIME, and ANSI TIMESTAMP string literals to the target DBMS. It is up to the target DBMS to perform coercion. If a coercion into the OpenROAD DATE variable is not supported, the coercion into a string literal can be supported.