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 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 |