HANA数据库使用记录
HANA数据库字符串转日期:
TO_VARCHAR(TO_DATE(T1.ERDAT,'YYYYMMDD'),'YYYY-MM-DD ') AS ERDAT,
HANA数据库having的使用方法:
having sum(T4.HSLVT)+sum(T4.HSL01) +sum(T4.HSL02) +sum(T4.HSL03) +sum(T4.HSL04) +sum(T4.HSL05) +sum(T4.HSL06) +sum(T4.HSL07) +sum(T4.HSL08) +sum(T4.HSL09) +sum(T4.HSL10) +sum(T4.HSL11) +sum(T4.HSL12)+sum(T4.HSL13)+sum(T4.HSL14)+sum(T4.HSL15)+sum(T4.HSL16) < 0