主表postgresql有两个时间字段
datatime(年月日时分秒),字段类型timestamp without time zone
minisecond,字段类型numeric
现在将两个字段拼接为一个字段,字段类型timestamp without time zone,用to_timestamp会直接转为timestamp with time zone
正确sql:
create or replace view *** as
select concat(datatime,'.',minisecond):: timestamp without time zone as datatime from table