The following table documents the valid inputs for tosql functionality.
| Source Input | Source Data Type of Routine Definition | Target Data Type of Routine Definition | Target Output |
|---|---|---|---|
|
BYTEINT | UDT | UDT |
| SMALLINT | |||
| INTEGER | |||
| BIGINT | |||
| DECIMAL NUMERIC | |||
| REAL FLOAT DOUBLE PRECISION | |||
|
BYTE | ||
| VARBYTE | |||
| BLOB | |||
|
CHARACTER | ||
| VARCHAR CHARACTER VARYING | |||
|
CLOB | ||
|
DATE | UDT | UDT |
|
TIME | ||
| TIME WITH TIME ZONE | |||
| TIMESTAMP | |||
| TIMESTAMP WITH TIME ZONE | |||
|
INTERVAL YEAR | ||
| INTERVAL YEAR TO MONTH | |||
| INTERVAL MONTH | |||
|
INTERVAL DAY | ||
| INTERVAL DAY TO HOUR | |||
| INTERVAL DAY TO MINUTE | |||
| INTERVAL DAY TO SECOND | |||
| INTERVAL HOUR | |||
| INTERVAL HOUR TO MINUTE | |||
| INTERVAL HOUR TO SECOND | |||
| INTERVAL MINUTE | |||
| INTERVAL MINUTE TO SECOND | |||
| INTERVAL SECOND |