(字段不够长,查询字段)
SELECT to_date(gz.jhsj,'YYYYMM') as build_time FROM gh_qyghgx gz
解决方式:检查qygh.jhsj的长度是否length(gz.jhsj)<6
(字段不够长,查询字段)
SELECT to_date(gz.jhsj,'YYYYMM') as build_time FROM gh_qyghgx gz
解决方式:检查qygh.jhsj的长度是否length(gz.jhsj)<6
转载于:https://www.cnblogs.com/523823-wu/p/8572991.html