此查询抛出错误:列"birthdate“的类型为timestamp,但表达式的类型为text INSERT INTO profile.profile(name,gender,birthDate,userId40', 'YYYY-MM-DD hh24:mi:ss') AS birthDate generate_series(1,10)
zone, _endperiod timestamp with time zone, _sort_field_and_direction charactervarying, _limit integer, _offset integer, OUT id integer, OUT customerid integer, OUT description charactervarying, OUT placedonvarying, _limit integer, _offset inte
在Postgres中是否有将BIGINT转换为TIMESTAMP或TIMESTAMP WITH TIME ZONE的方法?我需要将数据从BIGINT列复制到TIMESTAMP列。以下是我尝试过的:set date__timestamp = date__bigint::timestamp
错误:无法在没有时区的情况下将<e