Data Type | Default Conversion Function |
char | char(' ') |
c | c(' ') |
VARCHAR | VARCHAR(' ') |
INTEGER8 | INT8(0) |
INTEGER4 | INT4(0) |
INTEGER2 | INT2(0) |
INTEGER1 | INT1(0) |
FLOAT8 | FLOAT8(0) |
FLOAT4 | FLOAT4(null) |
DECIMAL | DECIMAL(0) |
ANSIDATE | ANSIDATE('') or ANSIDATE(null) |
TIME WITH TIME ZONE | TIME_WITH_TZ(' ') or TIME_WITH_TZ(null) |
TIME WITHOUT TIME ZONE | TIME_WO_TZ(' ') or TIME_WO_TZ(null) |
TIME WITH LOCAL TIME ZONE | TIME_LOCAL(' ') or TIME_LOCAL(null) |
TIMESTAMP WITH TIME ZONE | TIMESTAMP_WITH_TZ(' ') or TIMESTAMP_WITH_TZ(null) |
TIMESTAMP WITHOUT LOCAL TIME ZONE | TIMESTAMP_WO_TZ(' ') or TIMESTAMP_WO_TZ(null) |
TIMESTAMP WITH LOCAL TIME ZONE | TIMESTAMP_LOCAL(' ') or TIMESTAMP_LOCAL(null) |
INTERVAL DAY TO SECOND | INTERVAL_DTOS(' ') or INTERVAL_DTOS(null) |
INTERVAL YEAR TO MONTH | INTERVAL_YTOM(' ') or INTERVAL_YTOM(null) |
MONEY | MONEY(0) |