SAP_HANA常用sql合集——持续更新中

一、时间格式转换

(1)切换日期格式yyyymmdd的字段数据为yyyy-mm-dd

select
TO_VARCHAR(
        TO_DATE(t1.time1, 'YYYYMMDD'), 
        'YYYY-MM-DD'
    ) AS time1,
TO_VARCHAR(
        TO_DATE(t1.time2, 'YYYYMMDD'), 
        'YYYY-MM-DD'
    ) AS time2
from table

二、批量更新字段

（1）字段id大于等于12的全部加一

update target_table set id=id+1 where rule='10086' and B_field='B' and id >=12

三、插入查询语句到表中

(1)插入ETC查询结果

INSERT INTO database.target_table_name
with temp1 as(select t1.fields1 as field1
from database.source_table_name t1
where t1.fields1<>''),
with temp2 as(select t1.fields1 as field1
from database.temp1 t1
where t1.fields1='0')
select * from temp2