|
各位老师好，在使用数据库查询出，错误代码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 [dbo].[xpzhouqi] | 
