postgresql column is of type timestamp without time zone but expression is of type character varying解决

column is of type timestamp without time zone but expression is of type character varying解决

java插入postgresql问题:
ERROR: column is of type timestamp without time zone but expression is of type character varying
建议:You will need to rewrite or cast the expression.

解决:
jdbc:postgresql://127.0.0.1:5432/testdb?stringtype=unspecified
后面添加stringtype=unspecified,即自动格式化数据