abstime, reltime and tinterval, the verification task will report an error.abstime, reltime and tinterval are some older date and time types which have been deprecated in new PostgreSQL Versions. It is recommend using following types as alternatives:abstime: Can be substituted with timestamp or timestamp with time zone types. These types provide a broader range of date and time representation capabilities.reltime: Can be substituted with interval type. interval type is used to represent time intervals and can include units such as year, month, day, hour, minute, and second.tinterval: Can be substituted with tsrange or tstzrange types. These types are used to represent time ranges and can include start time and end time.abstime, reltime and tinterval are similar. First, create a new column. Convert the old data format to the new data format and store it in the new column. After verifying that the data in the new column is correct, delete the old column. Finally, rename the new column to the name of the old column as needed.abstime to timestamp as an example for introduction.ALTER TABLE your_table ADD COLUMN new_column TIMESTAMP;
UPDATE your_table SET new_column = your_abstime_column::TIMESTAMP;
SELECT * FROM your_table;
ALTER TABLE your_table DROP COLUMN your_abstime_column;
ALTER TABLE your_table RENAME COLUMN new_column TO your_abstime_column;
Esta página foi útil?
Você também pode entrar em contato com a Equipe de vendas ou Enviar um tíquete em caso de ajuda.
comentários