以下の表で、tosql機能に有効な入力内容を説明します。
| ソースの入力値 | ルーチン定義のソース データ型 | ルーチン定義のターゲット データ型 | ターゲットの出力 |
|---|---|---|---|
| BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION DATE CHARACTER VARCHAR | BYTEINT | UDT | UDT |
| SMALLINT | |||
| INTEGER | |||
| BIGINT | |||
| DECIMAL NUMERIC | |||
| REAL FLOAT DOUBLE PRECISION | |||
| BYTE VARBYTE BLOB | BYTE | ||
| VARBYTE | |||
| BLOB | |||
| CHARACTER VARCHAR CLOB BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION DATE | CHARACTER | ||
| VARCHAR CHARACTER VARYING | |||
| CHARACTER VARCHAR CLOB | CLOB | ||
| DATE BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION CHARACTER VARCHAR | DATE | UDT | UDT |
| TIME TIME WITH TIME ZONE CHARACTER VARCHAR | TIME | ||
| TIME WITH TIME ZONE | |||
| TIMESTAMP | |||
| TIMESTAMP WITH TIME ZONE | |||
| INTERVAL YEAR INTERVAL YEAR TO MONTH INTERVAL MONTH | 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 | 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 |