关于数据库查询出现,错误代码11300001 数据集配置错误
各位老师好,在使用数据库查询出,错误代码11300001 数据集配置错误,如何处理?
reportdate、sfdate两个数据类型均为datetime
SELECT reportdate,sfdate,sfdate-reportdate,round(to_number(substring(sfdate - reportdate,1,9))*24+to_number(substring(sfdate - reportdate,11,2))+to_number(substring(sfdate - reportdate,14,2))/60+to_number(substring(sfdate - reportdate,17,2))/(60*60),2) as av FROM .