Data Type | Default Conversion Function |
---|---|
char | char(' ') |
c | c(' ') |
varchar | varchar(' ') |
bigint (integer8) | int8(0) |
integer (integer4) | int4(0) |
smallint (integer2) | int2(0) |
tinyint (integer1) | int1(0) |
float (float8) | float8(0) |
real (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) |