diff options
Diffstat (limited to 'src/share/database/scripts/pgsql/dhcpdb_create.pgsql')
| -rw-r--r-- | src/share/database/scripts/pgsql/dhcpdb_create.pgsql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql index ecf417d587..40f1d3dc7e 100644 --- a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql +++ b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql @@ -4502,7 +4502,7 @@ AS $$ DECLARE gmt_epoch BIGINT; BEGIN - select extract(epoch from input_ts) + extract(timezone from input_ts) into gmt_epoch; + SELECT (extract(epoch from input_ts) + extract(timezone from input_ts))::BIGINT INTO gmt_epoch; RETURN gmt_epoch; EXCEPTION WHEN OTHERS THEN |