(字段不够长,查询字段)
SELECT to_date(gz.jhsj,'YYYYMM') as build_time FROM gh_qyghgx gz
解决方式:检查qygh.jhsj的长度是否length(gz.jhsj)<6
本文共 169 字,大约阅读时间需要 1 分钟。
(字段不够长,查询字段)
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